Neoview SQL Reference Manual (R2.2)

default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
column-constraint is:
NOT NULL
| PRIMARY KEY [ASC[ENDING] | DESC[ENDING]]
| CHECK (condition)
column-list is:
column-name [,column-name]...
table-constraint is:
PRIMARY KEY (key-column-list)
|CHECK (condition)
[NOT CASESPECIFIC]
key-column-list is:
column-name [ASC[ENDING] | DESC[ENDING]]
[,column-name [ASC[ENDING] | DESC[ENDING]]]...
like-spec is:
LIKE source-table [include-option]...
include-option is:
WITH CONSTRAINTS | WITH PARTITIONS
Syntax Description of CREATE TABLE
table
is the ANSI logical name for the new table and must be unique among names of tables, views,
and procedures within its schema.
NO INSERTLOG | INSERTLOG
specifies whether update and delete operations are recorded in the table’s IUD log, if one
exists.
When a table is defined with the INSERTLOG attribute, logging operations ignore delete
and update operations and log inserts only.
This logging is needed to maintain ON REQUEST materialized views. If no ON REQUEST
materialized views are defined on the table, this attribute has no affect.
NO PARTITION
creates a non-partitioned table. To create a non-partitioned table, specify the NO PARTITION
option in the CREATE TABLE statement.
If the NO PARTITION option is not specified, a partitioned table is created. When a partitioned
table is created, the table is automatically partitioned across all the disk volumes within a
disk pool.
MAX TABLE SIZE megabytes
specifies the table size as a number of megabytes.
If you do not specify MAX TABLE SIZE, a table is created with the following default
characteristics:
• For a partitioned table, the space allocated after you enter the first row is 100 MB times
number of partitions. The maximum size a partitioned table can reach is the size of the
CREATE TABLE Statement 71