Name
.indices — Display all of the indexes associated with one or more tables
Common Usage
.indices [table-pattern
]
Description
The .indices
command displays the name of different
indexes in the main
database.
If no parameter is given, the name of every index will be
displayed. If an optional table matching pattern is given, the
name of any index associated with a table that matches the
provided LIKE
pattern will be
displayed. Only one table pattern is permitted. Index names will
be returned one per line,
with no additional information.
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.