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-13
ALTER TABLE Statement
length)
[CHARACTER SET char-set-name] [COLLATE DEFAULT]
[UPSHIFT]
| VARCHAR (length) [CHARACTER SET char-set-name]
[COLLATE DEFAULT] [UPSHIFT]
| NUMERIC [(precision [,scale])] [SIGNED|UNSIGNED]
| NCHAR [(length) [CHARACTER SET char-set-name]
[COLLATE DEFAULT] [UPSHIFT]
| NCHAR VARYING(length) [CHARACTER SET char-set-name]
[COLLATE DEFAULT] [UPSHIFT]
| SMALLINT [SIGNED|UNSIGNED]
precision [,scale])] [SIGNED|UNSIGNED]
| PIC[TURE] [S]{ 9(integer) [V[9(scale)]] | V9(scale) }
[DISPLAY [SIGN IS LEADING] | COMP]
| FLOAT [(precision)]
| REAL
| DOUBLE PRECISION
| DATE
| TIME [(time-precision)]
| TIMESTAMP [(timestamp-precision)]
| INTERVAL { start-field TO end-field | single-field }
is:
literal
| NULL
| CURRENT_DATE
| CURRENT_TIME
| CURRENT_TIMESTAMP
| {CURRENT_USER | USER}
column-constraint is:
UNIQUE
| PRIMARY KEY [ASC[ENDING] | DESC[ENDING]]
| CHECK (condition)
| REFERENCES ref-spec
table-constraint is:
UNIQUE (column-list)
| PRIMARY KEY (key-column-list)
| CHECK (condition)
| FOREIGN KEY (column-list) REFERENCES ref-spec
column-list is:
column-name [,column-name]...
key-column-list is:
column-name [ASC[ENDING] | DESC[ENDING]]
[,column-name [ASC[ENDING] | DESC[ENDING]]...