DROP
DOMAIN
Name
DROP DOMAIN -- remove a user-defined
domain
Synopsis
DROP DOMAIN domainname [, ...] [ CASCADE | RESTRICT ]
Inputs
- domainname
-
The name (optionally schema-qualified) of an existing
domain.
- CASCADE
-
Automatically drop objects that depend on the domain
(such as table columns).
- RESTRICT
-
Refuse to drop the domain if there are any dependent
objects. This is the default.
Outputs
- DROP DOMAIN
-
The message returned if the command is successful.
- ERROR: RemoveDomain: type
'domainname' does not
exist
-
This message occurs if the specified domain (or type)
is not found.
Description
DROP DOMAIN will remove a user domain
from the system catalogs.
Only the owner of a domain can remove it.
Examples
To remove the box domain:
DROP DOMAIN box;
