Apache Cassandra 1.1 Documentation

DROP INDEX

This document corresponds to an earlier product version. Make sure you are using the version that corresponds to your version.

Latest Cassandra documentation | Earlier Cassandra documentation

Drops the named secondary index.

Synopsis

DROP INDEX <name>;

Description

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.

Example

DROP INDEX user_state;

DROP INDEX users_zip_idx;

CQL Commands

CQL Commands CQL Shell Commands
ALTER TABLE ASSUME
ALTER KEYSPACE CAPTURE
BATCH COPY
CREATE TABLE DESCRIBE
CREATE INDEX EXIT
CREATE KEYSPACE SHOW
DELETE SOURCE
DROP TABLE  
DROP INDEX  
DROP KEYSPACE  
INSERT  
SELECT  
TRUNCATE  
UPDATE  
USE