issue_comments: 850766335

Annoyingly the table.indexes property won't indicate if an index is in regular or reverse order - because the SQLite PRAGMA index_info(table) statement doesn't indicate that either. You have to look at the sqlite_master index definition to tell if any of the columns are in reverse order: (Pdb) fresh_db.execute("select * from sqlite_master where type = 'index'").fetchall() [('index', 'idx_dogs_age_name', 'dogs', 3, 'CREATE INDEX [idx_dogs_age_name]\n ON [dogs] ([age] desc, [name])')] (Pdb) fresh_db.execute("PRAGMA index_info('idx_dogs_age_name')").fetchall() [(0, 2, 'age'), (1, 0, 'name')] (Pdb) fresh_db.execute("PRAGMA index_info('idx_dogs_age_name')").description (('seqno', None, None, None, None, None, None), ('cid', None, None, None, None, None, None), ('name', None, None, None, None, None, None)) (Pdb) dogs.indexes [Index(seq=0, name='idx_dogs_age_name', unique=0, origin='c', partial=0, columns=['age', 'name'])]