1DROP DOMAIN(7)                   SQL Commands                   DROP DOMAIN(7)
2
3
4

NAME

6       DROP DOMAIN - remove a domain
7
8

SYNOPSIS

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

DESCRIPTION

14       DROP DOMAIN removes a domain. Only the owner of a domain can remove it.
15

PARAMETERS

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

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

42       CREATE DOMAIN [create_domain(7)], ALTER DOMAIN [alter_domain(7)]
43
44
45
46SQL - Language Statements         2011-09-22                    DROP DOMAIN(7)