SQL -Structured Query Language - SQL Table - Drop Table Tutorial

To drop or delete an existing created table and all its data, then we can use a ' DROP TABLE ' statement.

Syntax-

The basic syntax of the DROP TABLE statement is given below –

DROP TABLE table_name;

For example- 

If we want to drop the regions table

Then use the following syntax-

DROP TABLE regions;

Run Query

This query or statement will drop the whole regions table with all its columns.

One should always be secure while performing this query.

In Mysql Workbench- 

This query or statement will drop the whole emp_detail table with all its columns.