1DROP COLLATION(7)       PostgreSQL 9.2.24 Documentation      DROP COLLATION(7)
2
3
4

NAME

6       DROP_COLLATION - remove a collation
7

SYNOPSIS

9       DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP COLLATION removes a previously defined collation. To be able to
13       drop a collation, you must own the collation.
14

PARAMETERS

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

EXAMPLES

32       To drop the collation named german:
33
34           DROP COLLATION german;
35

COMPATIBILITY

37       The DROP COLLATION command conforms to the SQL standard, apart from the
38       IF EXISTS option, which is a PostgreSQL extension.
39

SEE ALSO

41       ALTER COLLATION (ALTER_COLLATION(7)), CREATE COLLATION
42       (CREATE_COLLATION(7))
43
44
45
46PostgreSQL 9.2.24                 2017-11-06                 DROP COLLATION(7)