.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';
.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';