Drop all tables from database in single query in mysql

Question

Yes i have searched for this but got solution for this in single query.

Any solution in MySQL to drop all tables(NOT TRUNCATE) from database in single query.

Why not dropping the database (all permissions are kept separately) ? — Denys Séguret, Dec 18 '13 at 12:21
you are right but just for knowledge any solution over this.Not any intention as such — Prashant Shilimkar, Dec 18 '13 at 12:23
dropping a database also drops all stored procedures defined. OP only wants to drop tables; — Ravinder Reddy, Dec 18 '13 at 12:33
Alternatively, If you are using PhpMyAdmin or Adminer, just click on the database name, then click on "select all" or top checkbox in the list of tables and hit "Drop", unless you have 100's of tables, this should be easy enough. — happyhardik, Nov 30 '20 at 13:51

score 26 · Accepted Answer · answered Dec 18 '13 at 16:55

26

As far as I know you have to do it individually: DROP TABLE user, settings, images

answered Dec 18 '13 at 16:55

Darren Lilley

1 Answers1