Query: drop_collation
OS: centos
Section: 7
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
DROPCOLLATION(7) PostgreSQL 9.2.7 Documentation DROP COLLATION(7)NAMEDROP_COLLATION - remove a collationSYNOPSISDROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DESCRIPTIONDROP COLLATION removes a previously defined collation. To be able to drop a collation, you must own the collation.PARAMETERSIF EXISTS Do not throw an error if the collation does not exist. A notice is issued in this case. name The name of the collation. The collation name can be schema-qualified. CASCADE Automatically drop objects that depend on the collation. RESTRICT Refuse to drop the collation if any objects depend on it. This is the default.EXAMPLESTo drop the collation named german: DROP COLLATION german;COMPATIBILITYThe DROP COLLATION command conforms to the SQL standard, apart from the IF EXISTS option, which is a PostgreSQL extension.SEE ALSOALTER COLLATION (ALTER_COLLATION(7)), CREATE COLLATION (CREATE_COLLATION(7)) PostgreSQL 9.2.7 2014-02-17 DROP COLLATION(7)