SQL-statement

SQL is spoken in finished sentences (statements) - they could end with a full stop. "Give me all rows with a 7 in the 3rd column in table horse." "Delete the row in pig, having 13 in the first column." There are different kinds of SQL statements. DDL (Data Definition Language) changes the structure of the database - creates a new database, deletes a table, creates a new column in an existing table etc. This kind of sentences usually begin with CREATE, but there are other choices. DML (Data Manipulation Language) affects the content of the database - creates a new row, deletes another row, changes a single value in a row etc. Maybe you're just looking at the database. This kind of sentences usually start with INSERT, UPDATE, DELETE and SELECT.

Concept last updated: 03/07 2003.

Relations

SQL

Create, alter, drop

is a kind of

Insert, update, delete

is a kind of

Select

is a kind of

SQL-statement

Other sources

InterBase tutorial mm. (obl.) - s. 12