SQL DROP TABLE  can be used to delete tables .

Example

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