A CREATE TABLE statement creates a table. Tables contain columns and constraints, rules to which data must conform. Table-level constraints specify a column or columns. Columns have a data type and can specify column constraints (column-level constraints).
The table owner and the database owner automatically gain the following privileges on the table and are able to grant these privileges to other users:
For
information about constraints, see
You
can specify a default value for a column. A default value is the value to
be inserted into a column if no other value is specified. If not explicitly
specified, the default value of a column is NULL. See
You
can specify storage properties such as page size for a table by calling the
If a qualified table name is specified, the schema name cannot begin with SYS.