Home / Database Structure / Tables / Question No: 80

I want to drop / delete my all existing tables from the database. Is it possible to drop them in one go?

To remove a table when you no longer need it, use the DROP TABLE statement:

DROP TABLES tbl_users;

In MySQL, a single DROP TABLE statement can name several tables to be dropped simultaneously. So you can use DROP TABLES statement giving table names separated by comma (,). Take an example as below:

DROP TABLES tbl_users,  tbl_category, tbl_products;

Normally, an error occurs if you attempt to drop a table that does not exist. To prevent an error from occurring if a table does not exist when you attempt to drop it, add an IF EXISTS clause to the statement:

DROP TABLE IF EXISTS no_such_table;

Note: If you drop a table by mistake, you must recover it from backups, so be careful.