Viewing tables graphically 1

[WillShakespeare]

All,

I am fairly new to SQL Admin, being quite a hand at programming web and client apps for dbs... and I remember someone showing me a graphical view of all the tables and how their relationships are.

I am in Enterprise manager but for the life of me can't remember how to create such a graphical listing so i can print it out on A3 or something and see what we are up against...

Can anyone help?

What I remember is a page full of rectangles (These were the tables) and lines between them (relationships).

Will

 

[gmmastros]

In enterprise manager, drill down to your database. Listed underneath it will be... [!]Diagrams[/!], Tables, Views, Stored Procedures, users, Roles, Rules, Defautls, User Defined Data Types, and User Defined Functions.

If there is nothing listed under diagrams, then one hasn't been created yet.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[WillShakespeare]

How do I create one?

 

[gmmastros]

Right click the word 'Diagrams', then 'New Database Diagram'.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[WillShakespeare]

Thanks. All too easy once you see through the trees!