<< ALTER DATABASE | FB 2.0 Language Reference | ALTER EXTERNAL FUNCTION >>

ALTER DOMAIN

Available in: DSQL, ESQL

Rename domain

Added in: IB

Description

Renaming of a domain is possible with the TO clause. This feature was introduced in InterBase 6, but left out of the Language Reference.

Example

 alter domain posint to plusint

• The TO clause can be combined with other clauses and need not come first in that case.

SET DEFAULT to any context variable

Changed in: IB

Description

Any context variable that is assignment-compatible to the domain's datatype can be used as a default. This was already the case in InterBase 6, but the Language Reference only mentioned USER.

Example

 alter domain DDate
 set default current_date

See also:
CREATE DOMAIN
CREATE TABLE
DROP DOMAIN
DDL - Data Definition Language

back to top of page
<< ALTER DATABASE | FB 2.0 Language Reference | ALTER EXTERNAL FUNCTION >>