Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (A-D)


ALTER DOMAIN statement

Use this statement to rename a user-defined domain or data type.

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.


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


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

Side effects

Automatic commit.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.


The following example renames the Address domain to MailingAddress:

ALTER DOMAIN Address RENAME MailingAddress;