Chapter 9 SQL Statements
393
table-constraint
:
{ UNIQUE (
column-name
, … )
| PRIMARY KEY (
column-name
, … )
} [ WITH [ MAX | MAXIMUM ] HASH SIZE
hash-size
]
| CHECK (
condition
)
|
foreign-key-constraint
foreign-key-constraint
:
[ NOT NULL ] FOREIGN KEY [
role-name
] [ (
column-name
, … ) ]
… REFERENCES
table-name
[ (
column-name
, … ) ]
… [
actions
] [ CHECK ON COMMIT ]
… [ WITH [ MAX | MAXIMUM ] HASH SIZE
hash-size
]
actions
:
[ ON UPDATE
action
] [ ON DELETE
action
]
action
:
CASCADE
| SET NULL
| SET DEFAULT
| RESTRICT
ALTER TABLE [
owner
.]
table-name
… REPLICATE { ON | OFF }
Must be one of the following:
♦ The owner of the table
♦ A user with DBA authority.
♦ A user granted ALTER permission on the table.
ALTER TABLE requires exclusive access to the table.
Global temporary tables cannot be altered unless all users that have
referenced the temporary table have disconnected.
Automatic commit.
The MODIFY and DELETE (DROP) options close all cursors for the current
connection.
A checkpoint is carried out at the beginning of the ALTER TABLE
operation.
Once you alter a column or table, any stored procedures, views or other items
that refer to the altered column no longer work.
"CREATE TABLE statement" on page 466
"DROP statement" on page 505
"SQL Data Types" on page 263
"Using computed columns with Java classes" on page 586 of the book ASA
User’s Guide
"Altering tables" on page 128 of the book ASA User’s Guide
Syntax 2
Permissions
Side effects
See also
To Next Page
Loading...