Request: "Drop all tables" command?

archfrog's profile image archfrog posted 7 years ago in General Permalink


I love HeidiSQL and use it virtually every day. I also use Laravel a lot. And I love Laravel too. However, Laravel is not very robust when it comes to handling errors during migration (automatic creation of tables) so if an error occurs, which happens frequently when you are setting up a new development box or testing changes to your Laravel migrations, you typically end up with a bunch of created tables that you need to delete again, to be able to retry the Laravel "artisan migrate:refresh" command.

Therefore, I'd like to request that the following feature be added to HeidiSQL:

If you right-click a database, there should be a "Drop tables" command. Or, it could be an additional tab in the "Table tools" window.

I basically need to delete all/many tables quickly. Right now I have to delete one table at a time, and in a large project with, say, 35+ tables, this does take a while and feels very tedious :-)

Cheers, Archfrog

ansgar's profile image ansgar posted 7 years ago Permalink

There is already Ctrl+A on the database tab, then a rightclick plus click on "Delete" should get you there.

I think deleting all tables with one click can be dangerous, and should not be made even easier than it is now.

archfrog's profile image archfrog posted 7 years ago Permalink

No, that's fine! That's all I needed, thanks.

francisco's profile image francisco posted 6 months ago Permalink

where is that? @ansgar I only can drop 1 by 1..

1 attachment(s):
  • Captura-de-ecr-2024-01-25-155824
archfrog's profile image archfrog posted 6 months ago Permalink
  1. You select the database you need to change on the left side.
  2. Then you get a window, in the right side, that lists all the tables in the database.
  3. Then you hit Ctrl-A to select all tables.
  4. Then you right-click and select "Drop...".

That should get you going :-) Hope it works for you!

Please login to leave a reply, or register at first.