DROP INDEX

Drop the named index.

Drop the named index.

Synopsis 

DROP INDEX name
Legend
  • Uppercase means literal
  • Lowercase means not literal
  • Italics mean optional
  • The pipe (|) symbol means OR or AND/OR
  • Ellipsis (...) means repeatable

A semicolon that terminates CQL statements is not included in the synopsis.

Description 

A DROP INDEX statement removes an existing index. If the index was not given a name during creation, the index name is <table_name>_<column_name>_idx.

Example 

DROP INDEX user_state;

DROP INDEX users_zip_idx;