MySQL: DROP TABLE Statement

Profile picture for user arilio666

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.

Tags