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.
NoteAny 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;