14,494 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Use the latest version of SQL Server Management Studio to create a Database Diagram.
Entity Relationship Diagram
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOD%3C/text%3E%3C/svg%3E)
Ordeal Dube
1
Reputation point
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 | Other
3 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2020-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 SSMSBest regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
-
Ordeal Dube 1 Reputation point
2020-11-26T05:55:34.763+00:00 Thanks @CathyJi-MSFT . Let me try that and get back to you
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2020-11-26T07:38:15.913+00:00 Waiting for your good news.
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
2020-11-30T08:46:57.897+00:00 Hi @Ordeal Dube ,
What is result for your test? By the way, if the response helped, do "Accept Answer".
Best regards,
Cathy
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,771 Reputation points2020-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.