Relationships from SQL Admin

[Len Boorman]

Struggling here but I believe that there is an Admin type facility that allows you to either create and display a Relationship Diagram or output the definition of all tables including Data Type, primary keys and Referenced keys as a series of SQL statements.

This would enable the re creation of the database structure.

Basically my problem is that I have a report writer that attaches to an SQL Server database but I have no relationship diagram. I am therefore funbling about in the dark but as I have said I believe there is an Admin option available.

I have had a look but cannot identify any likely candidates yet and am a bit wary at the moment. A few tips would be appreciated.

Len

 

[MadMaxx]

To create a Database Diagram here's what you do:

Open the Enterprise Manager
Open your SQL Server Instance
Right-click the database y ou want to diagram.
Select New->Database Diagram.
Select what tables you want to show in the diagram
Voila your done.

This diagram will show all relationship and keys for the tables you selected.

Hope this helps you out.

 

[Len Boorman]

That's brilliant Thanks a bunch. Had an inkling that it existed but needed a little guidance rather than fumbling in the dark

Cheers

len