ALTER DOMAIN statement

ALTER { DOMAIN | DATATYPE } user-type 
RENAME new-name

When you execute this statement, the name of the user-defined domain or data type is updated in the ISYSUSERTYPE system table.

Note

Any procedures, triggers, views, or events that refer to the user-defined domain or data type must be recreated, or else they continue to refer to the old name.

Must have DBA authority or be the database user who created the domain.

Automatic commit.

SQL/2008 Vendor extension. The ALTER DOMAIN statement is optional SQL feature F711 of the SQL/2008 standard. However, in the standard, ALTER DOMAIN can specify modified DEFAULT or CHECK constraint clauses for an existing domain. Neither of these operations are supported in SQL Anywhere. Feature F711 does not support the renaming of a domain.

The following example renames the Address domain to MailingAddress:

ALTER DOMAIN Address RENAME MailingAddress;

ALTER DOMAIN statement

Syntax

Remarks

Note

Permissions

Side effects

See also

Standards and compatibility

Example