Options
Feature Request: Expand wildcard with qualified column names
whenriksen
Posts: 25
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.
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
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.