SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-98
CREATE TABLE Statement
file-option is:
STORE BY store-option
| LOCATION [\node.]$volume[.subvolume.file-name]
[NAME partition-name]
| partn-file-option
| ATTRIBUTE[S] attribute [,attribute]...
store-option is:
PRIMARY KEY
| (key-column-list)
partn-file-option is:
{ [RANGE] PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD range-partn-defn [,ADD range-partn-defn]...)]
| HASH PARTITION
[BY (partitioning-column [,partitioning-column]...)]
[(ADD partn-defn [,ADD partn-defn]...)]}
range-partn-defn is:
FIRST KEY {col-value | (col-value [,col-value ]...)}
partn-defn
partn-defn is:
LOCATION [\node.]$volume[.subvolume.file-name]
[EXTENT ext-size | (pri-ext-size [,sec-ext-size])]
[MAXEXTENTS num-extents]
[NAME partition-name]
attribute is:
ALLOCATE num-extents
| {AUDITCOMPRESS | NO AUDITCOMPRESS}
| BLOCKSIZE number-bytes
| {CLEARONPURGE | NO CLEARONPURGE}
| EXTENT ext-size | (pri-ext-size [,sec-ext-size])
| MAXEXTENTS num-extents
like-spec is:
LIKE source-table [include-option]...
include-option is:
WITH CONSTRAINTS
| WITH HEADINGS
| WITH PARTITIONS
include-option is:
WITH CONSTRAINTS | WITH PARTITIONS