Menu
Friends, I am working on a issue in ERP which contains lots of Tables in it. I need to know the whole relationship between the table in a database to fix it. Is there any way to see all the Tables with their relationship among them of a database. I am using SQL Server Management Studio R2 64 bit OS.
561
Using SQL Server Management Studio Open the Table Designer for the table containing the foreign key you want to view, right-click in the Table Designer, and choose Relationships from the shortcut menu. In the Foreign Key Relationships dialog box, select the relationship with properties you want to view.
On the Database Tools tab, in the Relationships group, click Relationships. On the Design tab, in the Relationships group, click All Relationships. All tables that have relationships are displayed, showing relationship lines.
Open SQL Server Management Studio (SSMS). In the Object Explorer on the left, expand your database. Right-click on Database Diagrams, and then select New Database Diagram.
Open your SQL Server management studio and enter into your DB.
Enter into Database Diagrams and search for diagrams
If there is no diagram, create a new diagram (right mouse click - New Database Diagram)
Inside the Diagram use right mouse click, add all the relevant tables and see the relationships
You can see more info about DB Diagrams here
You can see here an example for diagrams with tables and relationships
76
Use database diagrams in management studio and see whole tables and relations .
42
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
