Viewing database diagrams in SQL Server is essential. In this article, I will walk you through all the approaches to do this.
How To View Database Diagram In SQL Server
Let us discuss all the approaches individually.
Approach-1: Using SQL Server Management Studio (SSMS)
To view database diagram in SQL server, follow the below steps.
1. Connect to your SQL Server instance using SQL Server Management Studio (SSMS).
2. Expand the Databases folder –> then Expand your specific database –> Now, expand the Database Diagrams folder as shown in the screenshot below.
You can double-click on the database diagram name to open it.
Check out How to Get Auto Increment ID in SQL Server
Approach-2: Using sysdiagrams
We can query the sysdiagrams for this purpose. We just need to execute the below query for this purpose.
USE Test;
GO
SELECT name AS DiagramName
FROM sysdiagrams;After executing the above query, I got the expected output below.
Conclusion
Viewing database diagrams in SQL Server is an essential skill. You can either use the SQL server management studio (SSMS) design approach or you can also query the sysdiagrams as mentioned in this article.
You may also like following the articles below.
- How To Find Database Name In SQL Server
- How to Find Stored Procedure in SQL Server
- How to View SQL Server Error Logs
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
