January 22, 2009 at 11:14 pm
Hi I have a database
I want to see the database diagram With relation ship(i.e) navigation flow
I my db diagram it doesn't display
also my tables dont have Fk it has only Pk(Primary Keys)
Pla give me the naviation
To see the relation ship of tables and keys
withregards
Lee
January 23, 2009 at 2:12 am
I would download the 14 day of the red gate tool, specifically the documentor as it gives all that info and more in a dynamic HTML format which can be viewed at any time, with or without the documetor once you have created the initial file..
January 23, 2009 at 3:06 am
There is no way to get the navigation flow, if you have not specified the FKs.
If wish to see the whole database in one document. see this link
http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx
Regards,
Nitin
January 23, 2009 at 6:18 am
So did you try what I laid out in the post you put up yesterday?
http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx
If it didn't work, what went wrong?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 23, 2009 at 6:39 am
Hey Lee,
As Grant has mentioned, you can create diagram using management studio. But It will give relations only if you have specified the FKs. If you didn't specify the FKs (as per your post), then there is no way to create relationship diagram using management studio.
You have to do manual exercise to create the diagram using some UML tool.
Regards,
Nitin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply