CODEWITHSUNDEEP
sql-server-2008
Gopichandar
Gopichandar

Reputation: 2832

Way for Seeing the Table relationship Tree for a Database?

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.

Upvotes: 13

Views: 71844

Answers (2)

Ofir
Ofir

Reputation: 5279

  1. Open your SQL Server management studio and enter into your DB.

  2. Enter into Database Diagrams and search for diagrams

  3. If there is no diagram, create a new diagram (right mouse click - New Database Diagram)

  4. Inside the Diagram use right mouse click, add all the relevant tables and see the relationships

    stage 1

Stage 4

You can see more info about DB Diagrams here

You can see here an example for diagrams with tables and relationships

Upvotes: 24

Amir Keshavarz
Amir Keshavarz

Reputation: 3108

Use database diagrams in management studio and see whole tables and relations .

Upvotes: 2

Related Questions