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

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.
LVL 16
Easwaran ParamasivamAsked:
Who is Participating?
 
Kent DyerIT Security Analyst SeniorCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Easwaran ParamasivamAuthor Commented:
I am using SQL server 2008 R2
0
 
BuggyCoderCommented:
0
 
Easwaran ParamasivamAuthor Commented:
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0
All Courses

From novice to tech pro — start learning today.