1DROP DOMAIN(7)           PostgreSQL 12.6 Documentation          DROP DOMAIN(7)
2
3
4

NAME

6       DROP_DOMAIN - remove a domain
7

SYNOPSIS

9       DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP DOMAIN removes a domain. Only the owner of a domain can remove it.
13

PARAMETERS

15       IF EXISTS
16           Do not throw an error if the domain does not exist. A notice is
17           issued in this case.
18
19       name
20           The name (optionally schema-qualified) of an existing domain.
21
22       CASCADE
23           Automatically drop objects that depend on the domain (such as table
24           columns), and in turn all objects that depend on those objects (see
25           Section 5.14).
26
27       RESTRICT
28           Refuse to drop the domain if any objects depend on it. This is the
29           default.
30

EXAMPLES

32       To remove the domain box:
33
34           DROP DOMAIN box;
35

COMPATIBILITY

37       This command conforms to the SQL standard, except for the IF EXISTS
38       option, which is a PostgreSQL extension.
39

SEE ALSO

41       CREATE DOMAIN (CREATE_DOMAIN(7)), ALTER DOMAIN (ALTER_DOMAIN(7))
42
43
44
45PostgreSQL 12.6                      2021                       DROP DOMAIN(7)