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-14

Syntax Description of ALTER TABLE

table

specifies the name of the table to alter. For more information, see Database Object

Names on page 6-13.

ADD [COLUMN] column-definition

adds a column to table.

The clauses for the column-definition are specified as:

column-name

specifies the name for the new column in the table. Column-name is an SQL

identifier. column-name must be unique among column names in the table. If

the column name is an SQL/MX reserved word, you must delimit it by

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

| CASCADE

| SET NULL

| SET DEFAULT

attribute is:

{ALLOCATE num-extents | DEALLOCATE}

| {AUDITCOMPRESS | NO AUDITCOMPRESS}

| {CLEARONPURGE | NO CLEARONPURGE}

| MAXEXTENTS num-extents

recalibrate-option is:

| RECALIBRATE

| RECALIBRATE TO signed-numeric-literal

| RECALIBRATE TO signed-numeric-literal NO SELECT

basic-sequence-generator-option is:

INCREMENT BY signed-numeric-literal

| MAXVALUE signed-numeric-literal