The CREATE Clause

Used to CREATE either a table or an index. In the simplest form, the syntax is:

CREATE TABLE tableName(field-definition-list)

"field-definition-list" is a comma-separated list containing the name of the field, the data type and, optionally, the field size (for text fields).

CREATE [ UNIQUE ] INDEX indexName
ON tableName (field-list)
[WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]

"field-list" is a comma-separated list containing the name of the field and (optionally) it's sort order (ASC or DESC)