DROP COLLATION

<< CREATE COLLATION | FB 2.5 Language Reference | COMMENT >>
<< CREATE COLLATION | FB 2.1 Language Reference | COMMENT >>

DROP COLLATION

Available in: DSQL

Added in: 2.1

Description

Removes a collation from the database. Only user-added collations can be removed in this way.

Syntax

 DROP COLLATION name

Tip: If you want to remove an entire character set with all its collations from your database, declare and run the stored procedure sp_unregister_character_set(name), found in misc/intl.sql under your Firebird installation directory.

See also:
CREATE COLLATION
Collate
Collation
Firebird 2.1 Release Notes: International language support (INTL)

back to top of page
<< CREATE COLLATION | FB 2.5 Language Reference | COMMENT >>
<< CREATE COLLATION | FB 2.1 Language Reference | COMMENT >>