Indexes

Indexes are listed in the Schema view of their parent table.

To add an index, use the add () button above the index list. To drop an index, select it and click the remove () button.

Info

For details on the language behind creating indexes, see the SQLite documentation

Adding an index

When adding an index, you need to give it a name, and select which columns it should include. An index must cover at least one column.

You can optionally add a WHERE clause to create a partial index.