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.


The new generation of project management tools

With’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
Easwaran ParamasivamAuthor Commented:
Easwaran ParamasivamAuthor Commented:
All Courses

From novice to tech pro — start learning today.