Drops the named secondary index.
DROP INDEX <name>;
A DROP INDEX statement removes an existing secondary index. If the index was not given a name during creation, the index name is <columnfamily_name>_<column_name>_idx.
DROP INDEX user_state;
DROP INDEX users_zip_idx;