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;