Information Modeling and Relational Databases, 2nd Edition

13.10. Summary

Base table schemes may be defined using a create-table statement,whose main syntax is:

create table tablename (
    colname           data-type          [not  null]
                                                [defaultiteral | nullluser]
                                                [primary key | unique   ]
                                                [ references   tablename]
                                                [check (col-condition-on-same-row) ]
     [,...]
    [, primary key (col-list) ]
    [, unique (col-list) ]
    [, foreign key (col-list) references tablename[ (unique-col-list) ] [ .... ]]
    [, check (table-condition-on-same-row) [ ....  ]])

In addition to creating tables by definition, as just shown, tables can also be created like another table or as the result of a select query. Other SQL statements exist for tasks such as altering and dropping tables, and equivalent alter or drop statements are available for other types of database ...