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 name | Column type | Meaning |
---|---|---|
seq
| Integer | Column sequence number |
cid
| Integer | Column index within table |
name
| Text | Name of column |
See Also
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.