How to Drop Table in Cassandra - Cassandra / CQL Tutorial

How to Drop a Table in Cassandra

Droping table in Cassandra is very easy. Change the keyspace in which your table is by using "Use KeyspaceName" or you can use fully qualified name "KeyspaceName.TableName" with below syntax.

Syntax:

CQLSH:techbrotherstutorials>DROP TABLE tablename;

 

Example:

If I have employee table in TechBrothersTutorials keyspace, I can use below script to drop it.

CQLSH:techbrotherstutorials>DROP TABLE employee;

Once you will run the script, Cassandra will execute it and prompt you on next screen after success. No Success message is displayed but if error occure then Cassanda will display message.