Neoview SQL Reference Manual (R2.5)

default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
table-constraint is:
PRIMARY KEY (key-column-list)
| CHECK (condition)
| FOREIGN KEY (column-list) REFERENCES ref-spec NOT ENFORCED
identity-column-specification is:
identity-type [(internal-sequence-generator-options)]
identity-type is:
GENERATED BY DEFAULT AS IDENTITY
| GENERATED ALWAYS AS IDENTITY
internal-sequence-generator-options is:
internal-sequence-generator-option ...
internal-sequence-generator-option is:
internal-sequence-generator-start-with-option
| basic-internal-sequence-generator-option
internal-sequence-generator-start-with-option is:
START WITH internal-sequence-generator-numeric-value
basic-internal-sequence-generator-option is:
internal-sequence-generator-increment-by-option
| internal-sequence-generator-maxvalue-option
| internal-sequence-generator-minvalue-option
| internal-sequence-generator-cycle-option
internal-sequence-generator-increment-by-option is:
INCREMENT BY internal-sequence-generator-numeric-value
internal-sequence-generator-maxvalue-option is:
MAXVALUE internal-sequence-generator-numeric-value
| NO MAXVALUE
internal-sequence-generator-minvalue-option is:
MINVALUE internal-sequence-generator-numeric-value
| NO MINVALUE
internal-sequence-generator-cycle-option is:
NO CYCLE
internal-sequence-generator-numeric-value is:
signed-numeric-literalinclude-option is:
WITH CONSTRAINTS | WITH PARTITIONS
key-column-list is:
column-name [ASC[ENDING] | DESC[ENDING]]
[,column-name [ASC[ENDING] | DESC[ENDING]]]...
like-spec is:
LIKE source-table [include-option]...
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.
SET
specifies a SET table, which is like any other normal table with the additional property of
discarding duplicate rows. A SET table does not generate duplicate row errors or warnings
CREATE TABLE Statement 73