ALTER TABLE statement
392
ALTER TABLE statement
Use this statement to modify a table definition or to enable a table to take
part in Replication Server replication.
ALTER TABLE [
owner
.]
table-name
… ADD
column-definition
[
column-constraint
… ]
| ADD
table-constraint
| MODIFY
column-definition
| MODIFY
column-name
DEFAULT
default-value
| ALTER
column-name
SET DEFAULT
default-value
| ALTER
column-name
DROP DEFAULT
| ALTER
column-name
SET COMPUTE (
expression
)
| ALTER
column-name
DROP COMPUTE
| MODIFY
column-name
[ NOT ] NULL
| MODIFY
column-name
CHECK NULL
| MODIFY
column-name
CHECK (
condition
)
| { DELETE | DROP }
column-name
| { DELETE | DROP } CHECK
| { DELETE | DROP } UNIQUE (
column-name
, … )
| { DELETE | DROP } PRIMARY KEY
| { DELETE | DROP } FOREIGN KEY
role-name
| RENAME
new-table-name
| RENAME
column-name
TO
new-column-name
column-definition
:
column-name
data-type
[ NOT NULL ] [ DEFAULT
default-value
]
column-constraint
:
{ UNIQUE
| PRIMARY KEY
| REFERENCES
table-name
[ (
column-name
) ] [
actions
]
} [ WITH [ MAX | MAXIMUM ] HASH SIZE
hash-size
]
| CHECK (
condition
)
| COMPUTE (
expression
)
default-value
:
string
|
global
variable
|
number
| AUTOINCREMENT
| CURRENT DATE
| CURRENT TIME
| CURRENT TIMESTAMP
| NULL
| TIMESTAMP
| USER
Function
Syntax 1
To Next Page
Loading...