Database and table creation

You can issue the create command to create a database.

create database database_name ;

You can issue the create command to create a table. When you create a table, you must define all the columns of the table as well as a datatype, such as text or integer, and if applicable, the column constraints and any default values.

create table database_name.table_name
(
        column_name [ constraints ] [ default default ] ,
        [ column_name [ constraints ] [ default default ] , ]
        [ additional_columns ]
        [ unique ( column_name ) , ]
        [ counter ( column_name ) , ]
        [ timestamp ( column_name ) ]
);

The entries within the brackets are separated by commas, although the last entry is not terminated by a comma.

The following topics describe how to use the create command.