Synonyms not being resolved Follow
Answered
I have a Sql Server database with synonyms which are able to be queries, but are not recognized by Intellisense.
"Unable to resolve table 'Currencies' less... (Ctrl+F1)
Inspection info: This inspection performs unresolved SQL references check."
Please sign in to leave a comment.
Please, share an example or the screenshot
Charles, could you please clarify what kind of synonyms do you use? Include code examples?
As far as I can see it's not synonyms are still not autocompleted, do u still need any examples?
Anyway, we need the screenshot with the synonyms shown in the database explorer
I have the same issue as well for MSSQL.
The synonyms display in the explorer, however in the text editor, they are unresolved. Error is "Unable to resolve Table Name"
I am using the fully qualified path [schema].synonymName
These synonyms are pointing to another table in a different database on the same server
The query runs fine.
Please, file a ticket here: https://youtrack.jetbrains.com/issues/DBE