Withdata Software

How to get index column names of a table from SQLite

select sql from sqlite_master
where tbl_name='my_table_name'
and type='index'

you can find the index name and column names in ‘sql’ field.

See also:

How to get index column names of a table from DB2

How to get index column names of a table from SQL Server

How to get index column names of a table from MySQL

How to get index column names of a table from PostgreSQL

How to get index column names of a table from Oracle

Some SQLite tools you can try: https://www.withdata.com/sqlite/