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.
Automatic commit.
SQL/2003 Vendor extension.
The following example renames the Address domain to MailingAddress:
ALTER DOMAIN Address RENAME MailingAddress; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |