How to Drop table in Cassandra?

Data Science, AI and ML
,
#1

Cassandra DROP table

DROP TABLE command is used to drop a table.

Syntax:

DROP TABLE <tablename>

Example:

Let’s take an example to demonstrate how to drop a table. Here, we drop the student table.

Prior table:

Cassandra Drop table 1

After using the following command:

How to find Nth Highest Salary in SQL

DROP TABLE student;

Cassandra Drop table 2

The table named “student” is dropped now. You can use DESCRIBE command to verify if the table is deleted or not. Here the student table has been deleted; you will not find it in the column families list.

DESCRIBE COLUMNFAMILIES;

Output:

Cassandra Drop table 3