1DROP DOMAIN()                    SQL Commands                    DROP DOMAIN()
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 will remove a domain. Only the owner of a domain can remove
15       it.
16

PARAMETERS

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

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

43       CREATE DOMAIN [create_domain(7)], ALTER DOMAIN [alter_domain(l)]
44
45
46
47SQL - Language Statements         2008-06-08                     DROP DOMAIN()