Reputation: 277
Is there an option to show a visual diagram of database tables and there relations? I have looked almost everywhere in the Solutions Explorer, but can't find anything!
Upvotes: 6
Views: 7801
Reputation: 456
Please go through the following link. That may help you
https://msdn.microsoft.com/library/ms171976(v=vs.110).aspx
"The Database Diagram Designer is a visual tool that allows you to design and visualize a database to which you are connected. When designing a database, you can use Database Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it."
Note Important
You can use the Database Diagram Designer to update databases in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. However, SQL Server 2012 doesn't support this feature.
Upvotes: 1