Cassandra DROP table

DROP TABLE command is used to drop a table.

Syntax:

1. DROP TABLE <tablename>   

Example:

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

Prior table:

After using the following command:

1. DROP TABLE student;   

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.

1. DESCRIBE COLUMNFAMILIES;   

Output: