Drop Table in SQL

The DROP TABLE statement is used to delete an existing table definition, indexes, constraints, access privileges and all associated data.


Note: When a table is deleted, all of the information in it is lost, so use it with caution.

Syntax:
DROP TABLE tableName;  

Example:

DROP TABLE EMPLOYEE;

Output:

Table dropped.