xxxxxxxxxx
DROP TABLE Customers;
-- Kindly upvote this answer if it helped you.
xxxxxxxxxx
DROP TABLE table;
DROP TABLE IF EXISTS table;
DROP TABLE table1, table2,
xxxxxxxxxx
-- 'DROP TABLE' followed by the name of the table you would like
-- to drop.
DROP TABLE `test_table`;
xxxxxxxxxx
DROP TABLE countries;
Code language: SQL (Structured Query Language) (sql)
xxxxxxxxxx
mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME