CREATE TABLE

CREATE TABLE

CREATE TABLE is used to create new database tables. To update the schema of an existing table, use ALTER TABLE. See Chapter 21 for more information.

• Input

CREATE TABLE tablename (        column    datatype    [NULL|NOT NULL]    [CONSTRAINTS],        column    datatype    [NULL|NOT NULL]    [CONSTRAINTS],        ... );