SqlDbx Forum

ptoniolo

Member

drop multiple tables

I think I found a minor bug in the 3.43 version of SqlDbx.

I want to drop all the tables in a mssql database: I select all the tables in the left pane, rightclick, choose "Drop...", confirm.

Well, the tables are all dropped, but the list on the left pane still shows half of the table names. But if you refresh the view, you realize that the list is actually empty.

I think that the problem is: you loop over the list to drop the tables, and you increment the loop index, even if the drop action have already removed the name from the list. Thus, you remove (from the list) only every other table.

This was a minor bug, just an error in the left pane display. But before realizing that the tables were actually dropped, I tried to select again the left pane, rightclick and drop. Well, I did not get any error from SqlDbx, and I believe this is a more serious error. I think that I should receive an error, saying: "Cannot drop the table, because it does not exist...".

Thanks
Pietro

sqldbxhelp

Administrator

Re: drop multiple tables

This was resolved in one of the updates to version 3.43.
Please download latest release.