View table relations and primary keys.

[perelo]

The problem I have is that I want to get the username from one database and the amount of messages for that user/s from another, the two databases are on the same server and the db_owner has got access to both databases.

I´m looking for a way to see the database relations between diffrent tables, is there any tool for this in enterprise manager?

Regards, Per E, Sweden

 

[vongrunt]

Yup. Create some diagrams from existing tables.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[perelo]

How is that done? I can´t find anything about diagrams in enterprise manager.

 

[perelo]

Sorry!! I found it! Some times you can´t see the forest for all the trees......