Entity Relationship Diagram

Ordeal Dube 1 Reputation point
2020-11-25T20:27:24.807+00:00

I have a work database that I restored in the 2017 MS SQL Server Management Studio. Unfortunately, it doesnt have an Entity Relationship Diagram - how the tables are linked. Is there a way I can get the diagram from the restored database? Currently, no one at my work place knows how the tables linked. Or even a way which can help me better understand the tables faster??

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,829 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. David Browne - msft 3,771 Reputation points
    2020-11-25T20:46:10.5+00:00

    Use the latest version of SQL Server Management Studio to create a Database Diagram.

    1 person found this answer helpful.
    0 comments
  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2020-11-26T02:19:12.667+00:00

    Hi @Ordeal Dube ,

    You can use SSMS 18.7.1 and follow the steps from below blog to create ER diagram.

    SQL Server Database Diagram Tool in Management Studio
    How to create ER diagram for existing SQL Server database with SSMS

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
  3. Tom Phillips 17,716 Reputation points
    2020-11-25T20:51:07.567+00:00

    Database diagrams will only help you if the tables have FKs setup between the tables. Otherwise, there is no way to programmatically determine the relationships.

    0 comments