Synonyms not being resolved
已回答
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, 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...