SQLite - testing for index?

Report · Nov 11, 2013

Hi

I have an AIR desktop app that loads an SQLite database into a datagrid.

I have a strange problem where, if I drop an index using "DROP INDEX IF EXISTS index1", then load the database again, the index won't drop (good), but if I restart the computer, then load the database again, the dropping process occurs, even though the index is not there.

I tested for the existence of the index by restarting, and loading the database in SQLite Administrator, and it's definitely NOT there.

My next step is to try purely testing for the existence of the index. I found this query online...

"SELECT * FROM SYS.indexes WHERE name='index1' AND object_id = OBJECT_ID('myTable')";

However, that gives me a "no such table: indexes" error.

Is there an indexes table of sorts that I can access in SQLite for AIR, and if so, how?

Thanks for taking a look.