SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-96
CREATE TABLE Statement
default is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
| {CURRENT_USER | USER}
identity-column-specification is:
identity-type [(internal-sequence-generator-options)]
[sg-location]
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 signed-numeric-literal
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 signed-numeric-literal
internal-sequence-generator-maxvalue-option is:
MAXVALUE signed-numeric-literal
| NO MAXVALUE
internal-sequence-generator-minvalue-option is:
MINVALUE signed-numeric-literal
| NO MINVALUE
internal-sequence-generator-cycle-option is:
NO CYCLE
sg-location is:
LOCATION [\node.]$volume[.subvolume.file-name]