how to drop all indexes of a sqlite table

Question

Hello,

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

I'm not aware that you can drop ALL indexes in one command - IMO you have to drop each by name. See also: http://www.sqlite.org/lang_dropindex.html Also, check this out for additional info: http://stackoverflow.com/questions/525512/drop-all-tables-command