Refactors and formats SQL code.
Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson
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.
- Posts: 16
- Joined: Thu Feb 18, 2010 5:07 pm
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.
- Posts: 330
- Joined: Mon Apr 19, 2010 1:44 pm
- Location: Cambridge, UK
Return to SQL Refactor 1
Who is online
Users browsing this forum: No registered users and 0 guests