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;