Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to get sql diagram from already deployed datab

Author  Topic 

khalednet85
Starting Member

1 Post

Posted - 2010-06-02 : 04:09:57
Hi Guys,

I am new employee in a company and I have sql server 2005 installed with a database for marketing, for example lets call it x, now this database has a set of tables with relations, I want to draw the database diagram (entity relatioship diagram) for this database to understand how things going on here, anyone has an idea how to genrate the database design?

asgast
Posting Yak Master

149 Posts

Posted - 2010-06-02 : 04:51:58
http://www.red-gate.com/products/sql_dependency_tracker/index.htm

you can google for something free, but this will let you know what to look for.
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2010-06-02 : 14:04:10
If Foreign Keys were used, easy: Click Database diagrams -> New database Diagram, lets call it x, then plop the tables on the Diagram.
Go to Top of Page
   

- Advertisement -