CREATE TABLE table_reference (column_reference data_type [NOT NULL], [, column_reference data_type [NOT NULL]...])
Description
Use the CREATE TABLE command when you want to add a new table to the database.
CREATE TABLE MyTable (
OrderNo AUTOINC,
OrderId CHAR(20) NOT NULL,
Customer LINK("Customer") NOT NULL,
OrderDate DATE NOT NULL,
Destination ENUM("Home", "Office", "PostBox")
)