Neoview SQL Reference Manual (R2.2)

attributes of a SELECT query and populates the table using the data returned by the SELECT
query. See “Database Object Names” (page 196).
CREATE [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 number]
[ATTRIBUTE {NO INSERTLOG | INSERTLOG}]
[{ALIGNED | PACKED}] FORMAT
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]...
identity-column-specification is:
GENERATED BY DEFAULT AS IDENTITY
data-type is:
CHAR[ACTER] [(length [CHARACTERS])]
[CHARACTER SET char-set-name]
[UPSHIFT]
| PIC[TURE] X [(length)] [CHARACTER SET char-set-name]
[DISPLAY] [UPSHIFT]
| CHAR[ACTER] VARYING (length)
[CHARACTER SET char-set-name]
[UPSHIFT]
| VARCHAR (length) [CHARACTER SET char-set-name]
[UPSHIFT]
| PIC[TURE] [S]{ 9(integer) [V[9(scale)]] | V9(scale) }
[DISPLAY [SIGN IS LEADING] | COMP]
| NCHAR [(length) [UPSHIFT]
| NCHAR VARYING(length) [UPSHIFT]
| NUMERIC [(precision [,scale])] [SIGNED|UNSIGNED]
| SMALLINT [SIGNED|UNSIGNED]
| INT[EGER] [SINGED|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 }
70 SQL Statements