How do I produce the relationship diagram in Microsoft Sql Server?
Here is a visual of what I am talking about here"
How do I produce the relationship diagram in Microsoft Sql Server?
Here is a visual of what I am talking about here"
Hi @Xarzu, could you please do "Accept Answer" for this thread if below anwsers helped you? By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Not sure that I understand the question. You seem to have created that diagram in SSMS, which has a fairly simple diagramming feature. But there is nothing else that ships with SQL Server.
There are a couple of third-party data-modelling tools out there, but they are not always cheap.
No, I did not produce this image myself in SSMS.
i found it somewhere and I am reposting the url link to it.
Please tell how to make use of this fairly simple diagramming feature.
Sorry about the misunderstanding. Anyway, Yufeishao's answer has all the details you need.
There have been a ER diagram designer in SSMS, AFAIK that feature was removed in a previous version.
Design Database Diagrams (Visual Database Tools)
Hi @Xarzu,
If you want to achieve the effect on your picture,you should create constraints and can add foreign key constraints to tie some tables together, and then create new database diagram.You better use the newest version of SSMS(SSMS18.0 temporarily removes this feature)
And this is a simple database diagram I created using foregin key constraint: 
https://www.mssqltips.com/sqlservertip/6269/sql-server-database-diagram-tool-in-management-studio/
17 people are following this question.