How to create a database database diagram in SQL Server

I created a database on sql server. Now I want to create a database diagram to establish a relationship between tables. but whenever I click the database chart option, the following error occurs. Please suggest me what should I do?

this error is occured

+3
source share
1 answer

Please read the message carefully. It states that diagrams cannot be added to the database if it does not have a valid login as owner. You can change it on the Files page of the database properties dialog box (right-click and select properties in the database). Set the owner to any valid login and diagrams will be included.

+5

All Articles