Neoview SQL Reference Manual (R2.4)

CREATE [SET][VOLATILE] TABLE table
(table-element [,table-element]...)
| table-spec | like-spec }
[NO PARTITION | HASH PARTITION BY
(partitioning-column, partitioning-column...)]
[MAX TABLE SIZE megabytes]
[DISK POOL pool_number]
[ATTRIBUTE {NO INSERTLOG | INSERTLOG}]
AS select-query
table-spec is:
(table-element [,table-element]...
table-element is:
column-definition
| [CONSTRAINT constraint-name] table-constraint
column-definition is:
column data-type
[DEFAULT default | NO DEFAULT |
identity-column-specification]
[[CONSTRAINT constraint-name] column-constraint]...
data-type is:
CHAR[ACTER] [(length [CHARACTERS])]
[CHARACTER SET char-set-name]
[UPSHIFT]
| CHAR[ACTER] VARYING (length)
[CHARACTER SET char-set-name]
[UPSHIFT]
| VARCHAR (length) [CHARACTER SET char-set-name]
[UPSHIFT]
| NCHAR [(length) [UPSHIFT]
| NCHAR VARYING(length) [UPSHIFT]
| NUMERIC [(precision [,scale])] [SIGNED|UNSIGNED]
| SMALLINT [SIGNED|UNSIGNED]
| INT[EGER] [SIGNED|UNSIGNED] | LARGEINT
| DEC[IMAL] [(precision [,scale])] [SIGNED|UNSIGNED
| FLOAT [(precision)]
| REAL
| DOUBLE PRECISION
| DATE
| TIME [(time-precision)]
| TIMESTAMP [(timestamp-precision)]
| INTERVAL { start-field TO end-field | single-field }
default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
CREATE TABLE Statement 71