#34 Improve "Generate Select in SQL Editor"

[m.hilpert]

... instead of selecting each column seperately. Usually,
you want to see all columns or just specific ones.
in addition, the current generated SQL statement with
lots of columns is longer than the window width. so you
always have to scroll to the right to see the table name.

better would be this format (2 lines!):

select *
from <tablename>

this is nicer to read and to edit. example i just want to
see some columns with a specific column value:

1. right click "Generate select in Sql Editor"
=>

select *
from <tablename>

edit the script:

select name, age, salary
from <tablename>
where name = 'Duke'

As you can see, it's more work to establish this with the
current implementation (i.e. select generation).

[m.hilpert]

Logged In: YES
user_id=667728

alternatively, leave "Gereate Select in SQL Editor" (perhaps
with better line breaking before "from" keyword) and offer an
additional function "Select All" that would opne a SQL Editor,
generate a "select * from tablename" and instantly executes
that statement. :-)