SQL:Data Definition Language

DDL Example
In the heights database the following DDL commands were sent to MySQL:

Examples
If we want to start the database again we may want to "DROP" it first.. but only if it already exists so:

Backus-Naur Form
For the complete format refer to [http://dev.mysql.com/doc/refman/5.0/en/create-table.html 12.1.10. CREATE TABLE Syntax (2010) ]

Examples
Note how we can create a template for the date.