21

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.

Improve this question
5
  • 1
    Why not dropping the database (all permissions are kept separately) ? Commented Dec 18, 2013 at 12:21
  • 4
    drop database ur_dbname ? Commented Dec 18, 2013 at 12:23
  • 2
    you are right but just for knowledge any solution over this.Not any intention as such Commented Dec 18, 2013 at 12:23
  • 4
    dropping a database also drops all stored procedures defined. OP only wants to drop tables; Commented Dec 18, 2013 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. Commented Nov 30, 2020 at 13:51

1 Answer 1

Reset to default
26

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.