Neoview SQL Reference Manual (R2.4)

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-literal
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.
72 SQL Statements