System table with relationships info

Hi,
Is there a system table in MS SQL that contains info about the relationships among the tables that are in the database?

Hoping for your reply...

novice
borntomessAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mnyeConnect With a Mentor Commented:
sysreferences in the database where the tables are whose relationships you want to check.  

A much easier way would be right clicking on a table in Enterprise Manager and selecting "Properties".  Micrsoft recommends not selecting from system tables as it can fragment you're indexes and slow down query response time.

for more info on columns for this table, check out microsoft Book Online.

hth
matt
0
 
borntomessAuthor Commented:
Thanks matt...Ill try it out. Its been of great help.

novice
0
 
CleanupPingCommented:
borntomess:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
monosodiumgCommented:
No comment has been added to this question in more than 268 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Accept: mnye http:#8197671

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

monosodiumg
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.