ALTER DOMAIN Statement

Renames a user-defined domain or data type. Does not rename Java types.

Quick Links:

Syntax

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

Parameters

(back to top)

new-name – an identifier representing the new domain name.

user-type – user-defined data type of the domain being renamed.

Examples

(back to top)

Example 1 – renames the Address domain to MailingAddress:
```
ALTER DOMAIN Address RENAME MailingAddress
```

Usage

(back to top)

The ALTER DOMAIN statement updates the name of the user-defined domain or data type in the SYSUSERTYPE system table.

You must recreate any procedures, views or events that reference the user-defined domain or data type, or else they will continue to reference the former name.

Side effects:

Automatic commit

Permissions

(back to top)

Must be the database user who created the domain or requires the ALTER DATATYPE or ALTER ANY OBJECT system privilege.