602SQL Documentation Index  

ALTER DOMAIN Statement

statement_ALTER_DOMAIN ::= ::= ALTER DOMAIN [scheme.]domain_name [ AS ] type 
   [ DEFAULT default_value ] [ NOT NULL ] [ internal_integrity_constraint ] [ evaluation ]
evaluation ::= INITIALLY { IMMEDIATE | DEFERRED }

The ALTER DOMAIN statement modifies the definition of an existing domain. The original definition is replaced with the new one. All tables that use the domain is will change structure.

Contrary to the SQL2 standard, this statement may do changes to domains and tables.

If the specified domain does not exist in the specified scheme the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) will occur.

See