SQL As Understood By SQLite

DROP INDEX

R-42037-15614:[The DROP INDEX statement removes an index added
with the CREATE INDEX statement.]
The index is completely removed from
the disk. The only way to recover the index is to reenter the
appropriate CREATE INDEX command.