Drop Table in SQL

241 Views
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.