SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-11
ALTER TABLE Statement
ALTER TABLE Statement
Considerations for ALTER TABLE
Examples of ALTER TABLE
The ALTER TABLE statement modifies an SQL/MX table by adding a column to the
table, by adding or dropping a constraint on the table, or by changing one or more file
attributes for the table. See Database Object Names on page 6-12.
ALTER TABLE table alter-action
alter-action is:
ADD [COLUMN] column-definition
| ADD [CONSTRAINT constraint] table-constraint
| DROP CONSTRAINT constraint [RESTRICT | CASCADE]
| ATTRIBUTE[S] attribute [,attribute]...
column-definition is:
column-name data-type
[DEFAULT default]
[HEADING 'heading-string' | NO HEADING]
[[CONSTRAINT constraint] column-constraint]...
data-type is:
CHAR[ACTER] [(length)[CHARACTERS]]
[CHARACTER SET char-set-name] [COLLATE DEFAULT]
[UPSHIFT]
| PIC[TURE] X [(length)][CHARACTER SET char-set-name]
[COLLATE DEFAULT] [DISPLAY] [UPSHIFT]
| CHAR[ACTER] VARYING (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]
| INT[EGER] [SIGNED|UNSIGNED]
| LARGEINT
| DEC[IMAL] [(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 }