View has unresolved refernce to the synonym in SSDT

Shivani Tyagi 106

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.

Any help is highly appreciated.

Thank you,
Shivani Tyagi

Ronen Ariely 15,186 Reputation points

2022-10-27T15:02:19.187+00:00

Good day,

SQL Server Data Tools (SSDT) is a feature of Visual Studio and not SQL Server.

As much as I know there is no specific forum (a tag) here for this tool and there should be one IMO.

In any case, it is not related to question about Transact-SQL (The tag you chose to use).

but the error did not resolved.

Which error?!?

Please provide the exact and full error

view is referring a synonym

A synonym is just an alternative name for another object. If you have a synonym of a table then just use it instead of the table name even if the VS does not find the synonym. It should work the same.

Please check if the following discussion i the old forum help you solve the issue:

https://social.msdn.microsoft.com/Forums/sqlserver/152759ac-8f03-471c-b79c-49f605fe12ba/unresolved-references-and-synonyms?forum=ssdt&WT.mc_id=DP-MVP-5001699

Share via

View has unresolved refernce to the synonym in SSDT