— ‘DROP TABLE’ followed by the name of the table you would like<br /> — to drop.<br /> DROP TABLE `test_table`;

DROP TABLE table;<br /> DROP TABLE IF EXISTS table;<br /> DROP TABLE table1, table2, …

DROP TABLE tablename;

DELETE FROM `table_name` [WHERE condition];

DROP TABLE IF EXISTS table1;

delete table query</p> <p>DROP TABLE <table name;<br /> e.g. DROP TABLE students;

DROP TABLE countries;<br /> Code language: SQL (Structured Query Language) (sql)

mysql –silent –skip-column-names -e “SHOW TABLES” DB_NAME | xargs -L1 -I% echo ‘DROP TABLE `%`;’ | mysql -v DB_NAME<br />