CREATE TABLE SQL Statement

CREATE TABLE table <column_name_type_list>

Used to create a table. Column_name_type_list is a comma-delimited list of expressions of the form: <<column_name> <column_type>>. For example:

CREATE TABLE mytable (myname char(10), age integer) creates a table with a myname column of 10 characters and an integer age column.

Note: Data types can be any ANSI SQL data type. Refer to any SQL reference for a list.