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 |
|
Sudhag
Starting Member
1 Post |
 Posted - 2010-01-04 : 04:53:10
|
| Hi all,Is there any one to help me in finding the solution for the below query?Query: How to get table relationship from parent table?Thanks,Micky |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-04 : 05:39:14
|
Look here, it might help (sp_depends):http://msdn.microsoft.com/en-us/library/ms189487(SQL.90).aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-01-05 : 02:00:05
|
| go through this linkhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137569&SearchTerms=INDEXPROPERTY |
|
|
|
balaganapathy.n
Starting Member
18 Posts |
Posted - 2010-01-05 : 08:40:43
|
| Just to add one more option:Type the Table name in the query window, then select the table name, now press keys Alt + F1, you will be displayed with the column list, and constraints, table(s) that reference(s) this table, and table that are being referenced by the table, etc.,balaganapathy n.Anything you can imagine is real. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-05 : 08:46:40
|
quote:
Originally posted by balaganapathy.n
Just to add one more option:Type the Table name in the query window, then select the table name, now press keys Alt + F1, you will be displayed with the column list, and constraints, table(s) that reference(s) this table, and table that are being referenced by the table, etc.,balaganapathy n.Anything you can imagine is real.
not bad 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
|
|
SQL Query