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

 

6 comments
Comment actions Permalink

Please, share an example or the screenshot

0
Comment actions Permalink

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

1
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

Please sign in to leave a comment.