DROP TABLE command is used to drop a table.
DROP TABLE <tablename>
Let’s take an example to demonstrate how to drop a table. Here, we drop the student table.
After using the following command:
How to find Nth Highest Salary in SQL
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.