Menu
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!
548
To connect to a database instance In Visual Studio, make sure that SQL Server Object Explorer is open. If it is not, click the View menu and select SQL Server Object Explorer. Right-click the SQL Server node in SQL Server Object Explorer and select Add SQL Server.
Right-click a table heading or column, and then click Create Relationship. In the Create Relationship dialog box, click the down arrow for Table, and select a table from the dropdown list. In a "one-to-many" relationship, this table should be on the "many" side.
Right-click on Tables and select Add New Table. The Table Designer opens and shows a grid with one default row, which represents a single column in the table that you're creating. By adding rows to the grid, you'll add columns in the table.
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.
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
