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.


is a kind of
is a kind of
is a kind of

Other sources

SQL SQL-statement Storyboard