DROP DOMAIN
Attention
This page documents an earlier version. Go to the latest (v2.3) version.Synopsis
Use the DROP DOMAIN statement to remove a domain from the database.
Syntax
drop_domain ::= DROP DOMAIN [ IF EXISTS ] name [ , ... ]
[ CASCADE | RESTRICT ]
drop_domain
Semantics
drop_domain
name
Specify the name of the existing domain. An error is raised if the specified domain does not exist (unless IF EXISTS is set). An error is raised if any objects depend on this domain (unless CASCADE is set).
IF EXISTS
Do not throw an error if the domain does not exist.
CASCADE
Automatically drop objects that depend on the domain such as table columns using the domain data type and, in turn, all other objects that depend on those objects.
RESTRICT
Refuse to drop the domain if objects depend on it (default).
Examples
Example 1
postgres=# CREATE DOMAIN idx DEFAULT 5 CHECK (VALUE > 0);
postgres=# DROP DOMAIN idx;
Example 2
postgres=# CREATE DOMAIN idx DEFAULT 5 CHECK (VALUE > 0);
postgres=# CREATE TABLE t (k idx primary key);
postgres=# DROP DOMAIN idx CASCADE;