JetSQL » Statements
SQL statements are used to access and manipulate data in a database.
SQL Data Manipulation Language (DML)
SQL (Structured Query Language) is a language used to execute queries. SQL Data Manipulation Language (DML) includes statements to retrieve, update, insert and delete records.
Important SQL DML Statements:
| SELECT | Retrieves data from a table. |
| UPDATE | Updates data in a table. |
| DELETE | Deletes data from a table. |
| INSERT INTO | Inserts new data into a table. |
SQL Data Definition Language (DDL)
SQL Data Definition Language (DDL) permits database tables, indexes, properties and constraints to be created, altered or deleted.
Important SQL DDL Statements:
| CREATE TABLE | Creates a new table. |
| CREATE INDEX | Creates a new index. |
| ALTER TABLE | Modifies a table. |
| DROP TABLE | Deletes a table. |
| DROP INDEX | Deletes an index. |
