In the original post I mention that refreshing the cache, etc didn't help. The synonyms work so obviously they refer to valid objects, if that's what you mean.
Synonyms that reference local database show as "Invalid object name 'mysynonym'" in intellisense in SSMS
Synonyms that reference local database show as "Invalid object name 'mysynonym'" in IntelliSense with SSMS 18.9.1, at least they do for me. I have found mentions of this "bug" going back to at least 2011. There is still no fix for this or workaround, other than defeating IntelliSense ? The use of synonyms isn't exactly rare. Having the query window full of red squiggles more or less defeats the utility of IntelliSense . I've tried opening, closing, clearing the IntelliSense cache, nothing works. It's like this on all of the SSMS instances I have access to.
Developer technologies | Transact-SQL
SQL Server | Other
3 answers
Sort by: Most helpful
-
-
kiln 11 Reputation points
2021-07-14T15:05:06.603+00:00 Anyone out there have useful input on this?
-
Tom Phillips 17,771 Reputation points
2021-07-14T17:49:19.45+00:00 I use synonyms a lot and do not have that issue using SSMS v18.9.1. It must be something to do with your cache.
I find Intellisense almost not worth bothering with. Some of the time it doesn't work at all.