Generate a diagram of tables and a relationships of existing SQL DB

[gk759]

Hi,

I am trying to generate a diagram of tables and a relationships of an existing SQL 2000 database. What is the best way to accomplish this ...I would appreciate your help."Diagrams" option in Enterprise Manager shows no items.

Thanks

Gary

 

[HestonJames]

Gary,

I've not done this with SQL2000 so cant make any guarantee's however I have used Microsoft VISO in the past which has a 'reverse engineer' feature and will diagram a database for you.

Last time I checked you can download a Trial version to get you going.

Heston

 

[gk759]

Heston,

I will try that and see.

Thanks a bunch!

Gary

 

[markros]

In SQL Server 2005 (and 2008) you just right click on Diagrams and then create a new diagram.