Parameters

Do not throw an error if the collation does not exist. A notice is issued in this case.

name

CASCADE

Automatically drop objects that depend on the collation.

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

Examples

To drop the collation named :

The command conforms to the SQL standard, apart from the IF EXISTS option, which is a Greenplum Database extension.

See Also

Parent topic: SQL Commands