Name

collation_list — List current collations

Common Usage

PRAGMA collation_list;

Description

The collation_list pragma lists all the active collations in the current database connection. This pragma will return a two-column table with one row per active collation.

Column name	Column type	Meaning
seq	Integer	Collation sequence number
name	Text	Name of collation

Unless an application has defined additional collations, the list will be limited to the built-in collations NOCASE, RTRIM, and BINARY.

See Also

database_list, sqlite3_create_collation() [C API, Ap G]