ALTER DOMAIN Statement

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

Syntax

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

Parameters

new-name: – an identifier representing the new domain name.
user-type: – user-defined data type of the domain being renamed.

Examples

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

Usage

The ALTER DOMAIN statement updates the name of the user-defined domain or data type in the SYSUSERTYPE system table. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > SYSUSERTYPE System View.

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.

See also Reference: Building Blocks, Tables, and Procedures > SQL Data Types.

Side effects:

Automatic commit

Permissions

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