Using SQLite

Name

index_list — List all indexes associated with a table

Common Usage

PRAGMA [database.]index_list( table_name );

Description

The index_list pragma lists all of the indexes associated with a table. The result set will contain one row for each index.

Column name	Column type	Meaning
seq	Integer	Index sequence number
name	Text	Name of index
unique	Integer	Is UNIQUE index

See Also

index_info, table_info