Solved

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

Posted on 2012-03-27
7
471 Views
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.
0
Comment
Question by:Easwaran Paramasivam
7 Comments
 
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.

HTH,

Kent
0
 
LVL 20

Assisted Solution

by:BuggyCoder
BuggyCoder earned 200 total points
ID: 37775164
0
 
LVL 9

Accepted Solution

by:
mimran18 earned 300 total points
ID: 37775186
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 16

Author Comment

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

Expert Comment

by:BuggyCoder
ID: 37775197
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 37775229
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 37775245
Thanks.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

821 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