1DROP COLLATION(7)        PostgreSQL 12.6 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, and in
26           turn all objects that depend on those objects (see Section 5.14).
27
28       RESTRICT
29           Refuse to drop the collation if any objects depend on it. This is
30           the default.
31

EXAMPLES

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

COMPATIBILITY

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

SEE ALSO

42       ALTER COLLATION (ALTER_COLLATION(7)), CREATE COLLATION
43       (CREATE_COLLATION(7))
44
45
46
47PostgreSQL 12.6                      2021                    DROP COLLATION(7)