How can we help you today? How can we help you today?

Intellisense: Wrong table columns returned for two tables with same name but different schema

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.
rick
0

Comments

1 comment

Sort by
  • FredericoJ
    Hi Rick,

    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
    FredericoJ
    0

Add comment

Please sign in to leave a comment.