v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

DROP INDEX

Synopsis

Use the DROP INDEX statement to remove an index and all of its data from the database.

Syntax

Diagram

DROPINDEXIFEXISTSindex_name

Grammar

drop_index ::= DROP INDEX [ IF EXISTS ] index_name;

Where

  • index_name is an identifier (possibly qualified with a keyspace name).

Semantics

  • An error is raised if the specified index_name does not exist unless IF EXISTS option is present.
  • Associated objects to index_name such as prepared statements will be eventually invalidated after the drop statement is completed.

Examples

ycqlsh:example> CREATE TABLE users(id INT PRIMARY KEY, name TEXT) WITH transactions = { 'enabled' : true };

ycqlsh:example> CREATE INDEX users_by_name ON users(name);

ycqlsh:example> DROP INDEX users_by_name;

See also