SQL DROP TABLE Statement

The SQL DROP TABLE Statement


The DROP TABLE statement in Structured Query Language is used to delete a table permanently.


Syntax for DROP TABLE in SQL

DROP TABLE table_name;

Here table_name is the name of the table in a database which you want to delete.

Below is the example for DROP TABLE Statement in SQL

DROP TABLE Employee;

This statement deletes a table named Employee.


NOTE: Be careful before dropping a database table because this deletion would result in loss of data stored in that table.

Previous Chapter - SQL CREATE TABLE Statement

Next Chapter

SHARE