Options
Intellisense: Wrong table columns returned for two tables with same name but different schema
rick@syncbak
Posts: 14 Bronze 2
in SQL Prompt
Please fix table schema resolution in intellisense.
SQL Prompt intellisense returns columns from the wrong table when I have two tables w/ same name but different schemas -- e.g., given audit.Shows and my.shows, the audit table column names are returned rather than the my.shows columns when the only table in the select is my.shows -- such as "TitleIsChanged" instead of "Title".
There is no reason I should see columns from audit.shows if the table isn't referenced in the query.
SQL Prompt intellisense returns columns from the wrong table when I have two tables w/ same name but different schemas -- e.g., given audit.Shows and my.shows, the audit table column names are returned rather than the my.shows columns when the only table in the select is my.shows -- such as "TitleIsChanged" instead of "Title".
There is no reason I should see columns from audit.shows if the table isn't referenced in the query.
Tagged:
Comments
Thank you for reporting this.
We've tried unsuccessfully to recreate the issue locally with the latest version of SQL Prompt (8.0.5.1758).
What version of SQL Prompt and SSMS/Visual Studio are you running?
Also, does anything change if you try to refresh the suggestions (Ctrl+Shift+D)?
Best regards,
Frederico
Redgate Software