Neoview SQL Reference Manual (R2.3)

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.
HASH PARTITION BY (partitioning-column, partitioning-column...)}
specifies the partitioning columns. If you do not specify the partitioning columns, the default
is the same partitioning column or columns as the base table.
Partitioning columns cannot be floating-point data columns.
CREATE TABLE Statement 71