Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
erncelen
Starting Member
15 Posts |
 Posted - 2005-05-17 : 17:11:22
|
I'm new in SQL server,and my question is...I was asked to identify the master table and the slave tables correlated in a large database with more than 100 tables.I mean ...in the case of 3 tables (a,b,c), table (a) has a primary key linked to table (b), and this one is linked with table (c).In this case is easy to identify the master table....---> a, and slaves b, and c, but in a large database ? Dependencies are too complicate. Is there a tool (also third party), or T-Sql procedure, scripts...which answers to my question (any tools can resolve dependencies)?I have tried to use the diagram provided by SQL Manager, but is impossible to undestand any table correlations.In the case of SQL Server diagram, how can I undearstand dependencies between tables?Thank to everybody, any help will be appreciated.... |
|
|
raclede
Posting Yak Master
180 Posts |
Posted - 2005-05-19 : 03:31:41
|
| to view the dependencies of particular table just right-click the table --> All Task -->Display DependenciesCursors are for those who doesn't know how to use SQL raclede™ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
|
|
Tables dependencies