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>;
mysql> drop table department; Query OK, 0 rows affected (0.31 sec) mysql>