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
Don't waste your time logging a ticket about this - I logged one 9 months ago (DBE-11371) fully documenting problem including screen shots - zero feedback, zero action to date. Come on guys, it can't be that hard! Or if it is a major technical issue for you to fix this be honest and admit it so that people considering paying big bucks for IDEA Ultimate or Datagrip can make a decision based on facts.
Tjr
It is in our roadmap for 2021.2
Patiently waiting...