Apache Cassandra 1.1 Documentation

DROP TABLE

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

Removes the named column family.

Synopsis

DROP TABLE <name>;

Description

A DROP TABLE statement results in the immediate, irreversible removal of a column family, including all data contained in the column family. You can also use the alias DROP TABLE.

Example

DROP TABLE worldSeriesAttendees;

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