Microsoft SQL Server 2019.Database Diagram not showing relationship and objects without dependencies

bsmartbkind — Wed, 29 Jul 2020 20:59:04 GMT

Hi Everyone. I have this situation.

After restore a database backup from another instance and generate Database Diagrams with apparently success, the diagrams are not showing any relationship between the tables. And when I see the dependencies for any table, there are no dependecies. The backup is from a commercial POS software that is been used for many business in my country.

What can cause relationships to not appear?

I do that before (restore and generate database diagrams) without problems.

Best regards,

Francisco

Re: Microsoft SQL Server 2019.Database Diagram not showing relationship and objects without dependen

stucotts — Wed, 05 Aug 2020 05:53:46 GMT

I am curious also, after a restore from a backup my main database diagram is absolutely empty. Has not been a problem in the past 9 years

topic Microsoft SQL Server 2019.Database Diagram not showing relationship and objects without dependencies in Developer

Microsoft SQL Server 2019.Database Diagram not showing relationship and objects without dependencies

Re: Microsoft SQL Server 2019.Database Diagram not showing relationship and objects without dependen