Add Purge option when dropping objects in object tree

[Claus Pedersen]

I have an redundant table and drop it by right-clicking on it and selecting drop. From version 10(?) of the database, the table is now placed in the recycle bin. I can now browse my way to the recycle bin, find the table, right-click and select Purge to finally purge the table and free up the used space.

1) Please add an option to PLD to purge directly when dropping an object. This could be as an extra Drop'n'Purge entry in the right click menu or an extra option in the dialog "Drop table myTable", "Would you like to purge the object" with an option "Don't show this message again" like in all other DSA dialogs

2) In the browser for recycle bin, the columns can not be viewed for a deleted table. The keys, check constraints etc. can be viewed with no problems (of course renamed to BIN...).

3) In the context menu for the recycle bin, the menu items properties, describe, view, browse, query data etc. do not work for a dropped table. Probably because the object name is not double quoted internally.
When querying data, the resulting select is:
select * from BIN$7a+WScaBScO+2gqOti+71w==$0 t
which of course will result in a syntax error. The object name must be double quoted like this:
select * from "BIN$7a+WScaBScO+2gqOti+71w==$0" t

 

[jking]

It would also be nice to be able "Purge All" by right-clicking the "Recycle bin" folder instead of having to do it on each table (or manually typing it).

Thanks.

 

[Claus Pedersen]

It is possible to mark some or all objects in the recycle bin, right-click and select Purge, but a Purge All option could be nice.