question

Xarzu avatar image
0 Votes"
Xarzu asked CarrinWu-MSFT commented

How do I produce the relationship diagram in Microsoft Sql Server?

How do I produce the relationship diagram in Microsoft Sql Server?
Here is a visual of what I am talking about here"
image002.png


sql-server-generalsql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered ErlandSommarskog commented

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

Sorry about the misunderstanding. Anyway, Yufeishao's answer has all the details you need.

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

There have been a ER diagram designer in SSMS, AFAIK that feature was removed in a previous version.

Design Database Diagrams (Visual Database Tools)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered Yufeishao-msft edited

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)
121799-8101.png
And this is a simple database diagram I created using foregin key constraint:
121864-8102.png
https://www.mssqltips.com/sqlservertip/6269/sql-server-database-diagram-tool-in-management-studio/


8101.png (9.5 KiB)
8102.png (6.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.