What are the challenges you face when working across database platforms? Take the survey

Feature Request, auto-prefix column list with alias.

istomtomistomtom Posts: 8
edited July 2, 2007 1:11PM in SQL Prompt Previous Versions
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.



  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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 Davis
    Red Gate Software Ltd
    Technical Support
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.