Parade Series - Sqlite3

.tables

sqlite> .schema data_dictionary

sqlite> CREATE INDEX idx_data_dictionary_1 ON data_dictionary (ID);

sqlite> .indices data_dictionary

sqlite> SELECT * FROM sqlite_master WHERE tbl_name = 'data_dictionary' AND type = 'index';