... and then query the sqlite_master for the
names of other indexes ...
Or use PRAGMA index_list(table-name) and PRAGMA index_info(index-name)
Regards
I am beginning to believe that maybe I was wrong in my
assumption that 'if a table has an index, that index shows in
sqlite_master'. Then my problem is now to find another way to
get index information for a table. Any suggestions?
Your assumption is correct. Where you are incorrect
Bogdan Ureche [EMAIL PROTECTED] writes:
I am beginning to believe that maybe I was wrong in my assumption that 'if a
table has an index, that index shows in sqlite_master'. Then my problem is
now to find another way to get index information for a table. Any
suggestions?
An index for an