Creating ER Diagram from SQL Server

[anikanchan]

Hi good fellas,

I am working with this huge SQL Server database that has no documentation. I was wondering if there is any way I can create the ER diagram from the tables in the database.

Any answer/input/suggestion is highly appreciated.

Thanks

Anikanchan

 

[SQLDenis]

Use Visio for Enterprise Architects and reverse engineer
or use ERWin
or use the built in diagram tool in SQL server under Database/diagrams



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[anikanchan]

Denis,

Thanks for your response. I was trying to use the SQL Diagram but the problem is that it does not give the relationships between the tables. Is there any way I can show it on the diagram without manually doing it. I have around 90 tables here.

Thanks again.

Anikanchan

 

[mrdenny]

The SQL Diagram uses the relationships which are defined on the tables. If there are no relationships defined on the tables (via forign keys) then the software doesn't know how to make the constraints.

Keep in mind that when you make the links in the SQL Diagram when you save the diagram it will place the forign keys on the tables.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com