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 nameColumn typeMeaning
seq IntegerIndex sequence number
name TextName of index
unique IntegerIs UNIQUE index

See Also

index_info, table_info