SQL - DROP TABLE

The SQL DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table.

The basic syntax of this DROP TABLE statement is:


DROP TABLE <Table Name>;

For example:
mysql> drop table department;
Query OK, 0 rows affected (0.31 sec)

mysql>