August 16, 2011 at 4:15 pm
I would like to use the database diagram in SSMS to generate a diagram for an existing database
so that I can see clearly foregin keys and relationships.
So in SSMS, I click database diagram, it first showed showed:
"This database does not have one or more of the support objects required to use database diagram. Do you wish to create them?"
I click yes, nothing happened, then I click it new diagram, it pops up a window for me to choose tables, then I have to manually add the relationships link for tables.
I suppose it will automatically generate the links by knowing what are the forign keys.
Is it true?
August 16, 2011 at 4:24 pm
It generally creates those links if the keys already exist.
Do you already have FKs defined?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 4:44 pm
Yes, we do have quite a few foreign keys created for some of the tables.
But the diagram only add tables, no replationship link at all.
August 16, 2011 at 5:38 pm
Interesting. Mine displays the links between tables for those that already have FKs defined.
I'd look at doing this through a different tool. You may not want to make any changes from the DB Diagram in SSMS. It will commit those changes to your db.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply