Comments
2 comments
-
If you code your SELECT then, on a newline, code your FROM clause, with table aliases, you can readily return to the SELECT and PromptSQL will show you the columns when you type the table alias.
You get used to it quite quickly... -
I also found that if you type the following:
SELECT *
FROM Accounts
WHERE
you get the correct list of columns from the accounts table after the where clause.
However, if you using spacing like:
SELECT *
FROM Accounts
WHERE
you will get a list of table names after the where clause, instead of the column names. The space between lines causes problems elsewhere as well... I would like to see this work on the final release because the SQL statements that I work with are all written with the spaces.
Add comment
Please sign in to leave a comment.
it defaults the 2nd fields tablename to "tblCustomer", which is a good behaviour as I'm likely to select a series of fields from the same table. However it only does this for the first instance, if I add a new field it resets to the list of all objects after the 2nd <CTRL+SPACE>
Cathal