Feature Request, auto-prefix column list with alias.

istomtom

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

Eddie D

Hi Tom

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