Name
DROP INDEX — Delete a table index from a database
Syntax
Common Usage
DROP INDEXdatabase_name
.index_name
;
Description
The DROP
INDEX
command deletes an explicitly created
index. The index and all the data it contains is deleted from
the database. The table the index references is not modified.
You cannot drop automatically generated indexes, such as those
that enforce unique constraints declared in table
definitions.
Dropping an index that does not
exist normally generates an error. If the optional IF EXISTS
clause is provided,
this error is silently ignored.
See Also
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.