ContextQMD
Back to Turso

DROP INDEX

docs/sql-reference/statements/drop-index.mdx

0.5.31.4 KB
Original Source

DROP INDEX

Remove an index from the database. The underlying table and its data are not affected.

Syntax

sql
DROP INDEX [IF EXISTS] [schema-name.]index-name;

Description

DROP INDEX removes a previously created index. After the index is dropped, the query planner can no longer use it to optimize queries. The table data is unchanged.

Parameters

ParameterDescription
IF EXISTSPrevents an error if the index does not exist. The statement is a no-op when the index is absent.
schema-nameThe name of the attached database containing the index. Defaults to the main database if omitted.
index-nameThe name of the index to drop.

Behavior

  • Only explicitly created indexes can be dropped. Indexes automatically created for PRIMARY KEY and UNIQUE constraints cannot be dropped directly -- drop the table or use ALTER TABLE instead.
  • Dropping an index may degrade query performance for queries that relied on it, but does not affect correctness.

Examples

Drop an Index

sql
DROP INDEX idx_users_email;

Drop an Index Only if It Exists

sql
DROP INDEX IF EXISTS idx_old_search;

Drop an Index in an Attached Database

sql
DROP INDEX aux.idx_sessions_token;

See Also