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.

Permissions

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

Side effects

Automatic commit.

See also

• ISYSFILE system table
• CREATE DOMAIN statement
• Domains
• Using domains

Standards and compatibility

Example

The following example renames the Address domain to MailingAddress:

ALTER DOMAIN Address RENAME MailingAddress;