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
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.