Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/lsp4you/public_html/connect.php on line 2
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>