Mechanism for seeing indexes on a specific table

[simonw]

The only way to see the indexes that apply to a specific table at the moment is to run the following SQL manually:

select * from sqlite_master where type = 'index' and tbl_name=?

For example:

It would be good if this list of indexes was displayed in a neater way on the table page.

[simonw]

Easiest solution here would be to append these on to the create table statement that is displayed on the table page.

[simonw]

Demo: https://latest.datasette.io/fixtures/compound_three_primary_keys#export