Competition: What’s your favorite Redgate tool? Enter now.

Feature Request: Expand wildcard with qualified column names

whenriksenwhenriksen Posts: 25
edited December 20, 2010 10:00AM in SQL Refactor Previous Versions
Can an option be added to qualify column names when expanding a wildcard?

I regularly run into tables with matching column names. When I use the expand wildcard feature with a join, I end up with 'ambigous column' references since the matching column names are not qualified.

At that point the Qualify Object Names feature won't fix it because Refactor no longer knows which column belongs to which table.

Comments

  • Thank you for your suggestion.

    Unfortunately there will be no further development work on SQL Refactor. This is because the functionality (including Qualify Object names) has been incorporated into SQL Prompt, which has just been released (as SQL Prompt 5).

    If you are able to, I would recommend trying out SQL Prompt 5 to see whether there has been an improvement over SQL Refactor. If not, then please reply to this post and we will raise a Bug Report for the development team to look into.
Sign In or Register to comment.