Feature Request, auto-prefix column list with alias.
istomtom
Posts: 8
I have auto aliasing turned on, so I get the following:
SELECT * FROM CreditType ct (the 'ct' is automatically inserted by sqlprompt).
If I then put the cursor after * and hit tab I get the expanded column list but WITHOUT the alias on the columns (as below). It would be nice if sqlprompt prefixed the column list items with the ct. alias.
SELECT CreditTypeID,
CreditType FROM CreditType ct
Just a thought.
-Tom
SELECT * FROM CreditType ct (the 'ct' is automatically inserted by sqlprompt).
If I then put the cursor after * and hit tab I get the expanded column list but WITHOUT the alias on the columns (as below). It would be nice if sqlprompt prefixed the column list items with the ct. alias.
SELECT CreditTypeID,
CreditType FROM CreditType ct
Just a thought.
-Tom
Comments
Thank you for your suggestion.
I have submitted a feature request on your behalf. Hopefully your suggestion will gain approval and appear in a later version of SQL Prompt.
Many Thanks
Eddie
Eddie Davis
Red Gate Software Ltd
Technical Support
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com