Name

index_info — List table and columns contained in an index

Common Usage

PRAGMA [database.]index_info( index_name );

Description

The index_info pragma queries information about a database index. The result set will contain one row for each column contained in the index.

Column nameColumn typeMeaning
seq IntegerColumn sequence number
cid IntegerColumn index within table
name TextName of column

See Also

index_list, table_info