Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How to identify/obtain all the relationship diagrams to know relationship between the tables?

Posted on 2012-03-27
Medium Priority
Last Modified: 2012-08-14
Hi Experts,

  I have a DB (which is already contains required tables, SPs, Views, and so on). All what I want to get is obtain ALL data model diagrams which identify the relationship between the tables.
Is there any way for that? So that I could understand the existing application clearly.

Say for example If the database contains 4 tables where 2 tables related with each other and another 2 tables have relationship. But 4 tables are not realted together. In this case I want to get 2 diagrams.

  Please let me know if easy way to achieve it. Thanks.
Question by:Easwaran Paramasivam
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 17

Expert Comment

by:Kent Dyer
ID: 37775139
What version of SQL server are you running?  I know pretty much all of the way back to SQL 2000 offer table diagramming..  I would have to assume SQL 7.0 offered it too.


LVL 20

Assisted Solution

BuggyCoder earned 800 total points
ID: 37775164

Accepted Solution

mimran18 earned 1200 total points
ID: 37775186
Quick Cloud Training

Looking for some quick training on the cloud in 2 hours or less? Check out these how-to guides in AWS, Linux, OpenStack, Azure, and more!

LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 37775194
I am using SQL server 2008 R2
LVL 20

Expert Comment

ID: 37775197
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 37775229
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 37775245

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question