May 11, 2009 at 4:39 pm
i have a user database with 210 tables. i was wondering, how could i check tables relationship among each other without checking with developers? Is there a way, we could do this?
appreciated any input.
many thanks,
cali
May 11, 2009 at 10:41 pm
Yes, it is possible, with Database Diagram in SQL Server Management Studio.
Expand the database node. Right click on Database Diagram. Select New Diagram....
May 11, 2009 at 10:51 pm
Actually this is not sufficient. Very for database schemata physically implement all the relationships between tables as Foreign Keys. For the most databases, the logical relationships are left implicit.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply