how to drop all indexes of a sqlite table

Question

I have a simple question: How to drop all indexes of a sqlite table? I have multiple indexes created with random name.

Regards,
Pentium10

Answer 1

To get all index names in a database

SELECT name FROM sqlite_master WHERE type == 'index'

For a specific table:

SELECT name FROM sqlite_master WHERE type == 'index' AND tbl_name == 'table Name'

Then in your language, iterate thought the results and drop them

FOR x IN RESULTSET
  SQL = "DROP INDEX " & X