A very nice feature which I picked up from DbVisualizer
is the concepts of shortcuts. (I am not sure that
"shortcuts" is what they call it.)
What basically happens is that when one clicks on the
content tab of a table or view (and see the data in the
table) one can right click and get options like Select
all, Select count, Select, Delete, Insert, Update,
Say I chose the first three columns of a row in a table
and select Delete. It will then take me to the SQL
section, where a delete from table_name, where ...
clause will have been pasted with the thee columns
names and pre-populated values.