View has unresolved refernce to the synonym in SSDT

Shivani Tyagi 106 Reputation points
2022-10-20T11:13:32.807+00:00

Hi,

I am trying to build the database testing project, where a view is referring a synonym which is residing in other schema.
I have tried to add reference to the new database project where the table resides, but the error did not resolved.
I also cannot find this setting in my project properties -

"Enable extended Transact-SQL verification for common objects" - which everyone is saying to uncheck to resolve this issue but it is not present anywhere.

252433-image.png

Any help is highly appreciated.

Thank you,
Shivani Tyagi

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,584 questions
{count} votes