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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

ALTER DBSPACE statement Next Page

ALTER DOMAIN statement


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

Syntax

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

Remarks

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 will continue to refer to the old name.

Permissions

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

Side effects

Automatic commit.

See also
Standards and compatibility
Example

The following example renames the Address domain to MailingAddress:

ALTER DOMAIN Address RENAME MailingAddress;