The exact opposite of CREATE, the DROP statement drops/deletes the provided table in the query. Note that when dropping a table, be careful on which table you choose to drop a wrong move can permanently delete the table and its records within it.

Syntax

DROP TABLE TableName;

Example

DROP Table accounts;

The following query dropped/deleted the accounts table.

Related Content
MySQL Tutorial
MySQL: Create Table Using Another Table
MySQL: Describe Table
Tags
MySQL