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
  • SQL/2003   Vendor extension.

Example

The following example renames the Address domain to MailingAddress:

ALTER DOMAIN Address RENAME MailingAddress;