Is there a preference to have the list of column names not show tablename.column currently the list shows all of the colum names with tablename.colum as well as just the column name or have a quick key sequence to turn this on and off so that at time you do need the tablename.colum you can get it.
Comments
2 comments
-
i normally alias the table first like so:
FROM tablename as a
Then the columns list is prefixed with the letter "a" instead of "tablename" -
I alias mine as well but sometimes when you dealing with a huge table it can get confusing with two entries one with table alias and then just the column. You can't always alias tables with one character cuse in a large query you ay have already used that alias and so you may have to use something like addr for address table when linking to the accounts a table.
Add comment
Please sign in to leave a comment.