Creating tables

Creating tables

CREATE TABLE table_name (column_name column_type [, column_name column_type]...);

All users have privileges to create tables.

The following example creates a new table named TEST with the column I of the column type INTEGER and the column TEXT of the column type VARCHAR.

CREATE TABLE TEST (I INTEGER, TEXT VARCHAR);