Share via

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

Xarzu 1 Reputation point
Aug 9, 2021, 8:28 PM

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,294 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,306 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 115.3K Reputation points MVP
    Aug 9, 2021, 9:29 PM

    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. Olaf Helper 45,616 Reputation points
    Aug 10, 2021, 5:30 AM

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

    Design Database Diagrams (Visual Database Tools)

    0 comments No comments

  3. YufeiShao-msft 7,131 Reputation points
    Aug 10, 2021, 6:18 AM

    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/

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.