Solved

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

Posted on 2012-03-27
7
464 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

758 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now