1DROP DOMAIN(7)          PostgreSQL 9.2.24 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).
25
26       RESTRICT
27           Refuse to drop the domain if any objects depend on it. This is the
28           default.
29

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

40       CREATE DOMAIN (CREATE_DOMAIN(7)), ALTER DOMAIN (ALTER_DOMAIN(7))
41
42
43
44PostgreSQL 9.2.24                 2017-11-06                    DROP DOMAIN(7)
Impressum