DROP TABLE

Grammar Description

This statement is used to delete a table from the currently selected database, and an error will be reported if the table does not exist unless the IF EXISTS modifier is used.

Grammar Structure

> DROP TABLE [IF EXISTS] [db.]name

Example

CREATE TABLE table01(a int);

mysql> DROP TABLE table01;
Query OK, 0 rows affected (0.01 sec)