|CQL reference / CQL commands|
Drop the named index.
DROP INDEX IF EXISTS index_name
In the synopsis section of each statement, formatting has the following meaning:
A semicolon that terminates CQL statements is not included in the synopsis.
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. If the index does not exists, the statement will return an error, unless IF EXISTS is used in which case the operation is a no-op.
DROP INDEX user_state; DROP INDEX users_zip_idx;