SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-75
CREATE TABLE Statement
default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
| {CURRENT_USER | USER}
column-constraint is:
NOT NULL [[NOT] DROPPABLE]
| UNIQUE
| PRIMARY KEY [ASC[ENDING] | DESC[ENDING]]
[[NOT] DROPPABLE]
| CHECK (condition)
| REFERENCES ref-spec
ref-spec is:
referenced-table [(column-list)]
[referential triggered action]
referential triggered action is:
update rule [delete rule]
| delete rule [update rule]
update rule is: ON UPDATE referential action
delete rule is: ON DELETE referential action
referential action is:
RESTRICT
| NO ACTION
column-list is:
column-name [,column-name]...
table-constraint is:
UNIQUE (column-list)
| PRIMARY KEY (key-column-list) [[NOT] DROPPABLE]
| CHECK (condition)
| FOREIGN KEY (column-list) REFERENCES ref-spec
key-column-list is:
column-name [ASC[ENDING] | DESC[ENDING]]
[,column-name [ASC[ENDING] | DESC[ENDING]]]...
file-option is:
STORE BY store-option
| LOCATION [\node.]$volume[.subvolume.file-name]
[NAME partition-name]
| partn-file-option
| ATTRIBUTE[S] attribute [,attribute]...