SQLite里的SQL
SQL As Understood By SQLite

[Top]

DROP INDEX

drop-index-stmt: 隐藏

DROP INDEX语句移除一个由CREATE INDEX创建的索引。索引会从磁盘上彻底移除。恢复索引的唯一办法就是使用CREATE INDEX命令重新创建一个。
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.