Relationship of primary and foreign keys

[cocopud]

Someone requested documentation on the relationships of the primary and foreign keys of the tables in our database. We are using SQL Server 2000 and was wondering what the best/easist way to do this would be.

 

[ptheriault]

Are you looking to create a diagram? If so I use Visio to export databases into diagrams. I find it very easy to use. There is also Erwin and SQL Server has the ability from with the database to create a diagram.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Visio is a pretty standard tool for this task. It has the abality to reverse engineer the schema from the actual database.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com

 

[Crowley16]

as far as I know, you have to have visio enterprise to be able to do that...

--------------------
Procrastinate Now!