Feature Request: Expand wildcard with qualified column names

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

Feature Request: Expand wildcard with qualified column names

Postby whenriksen » Thu Dec 16, 2010 11:53 pm

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.
whenriksen
 
Posts: 16
Joined: Thu Feb 18, 2010 5:07 pm

Postby chriskelly » Mon Dec 20, 2010 4:00 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.
chriskelly
 
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 1 guest