Synonyms not being resolved

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."

 

9 comments
Comment actions Permalink

Charles, could you please clarify what kind of synonyms do you use? Include code examples?

1
Comment actions Permalink

Please, share an example or the screenshot

0
Comment actions Permalink

As far as I can see it's not synonyms are still not autocompleted, do u still need any examples?

 

 

 
0
Comment actions Permalink

Anyway, we need the screenshot with the synonyms shown in the database explorer

0
Comment actions Permalink

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.

 

 

 

0
Comment actions Permalink

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.

0
Comment actions Permalink

Tjr

It is in our roadmap for 2021.2

0
Comment actions Permalink

Patiently waiting...

0

Please sign in to leave a comment.