sqlitedocs.com

An unofficial interface for the excellent SQLite docs.

Whenever I was using SQLite docs I wished for some tiny quality of life enhancements. I've added them here. Maybe you'll find them useful.

I try to follow the credo of less-bs so no ads or tracking here.

Thanks to SQLite, Algolia, Netlify, and Twemoji.

Small. Fast. Reliable.
Choose any three.
DROP INDEX

drop-index-stmt:

DROP INDEX IF EXISTS schema-name . index-name

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.