Question:

Is it possible to find out which other tables a table is linked to in SQL server 2005?

by  |  earlier

0 LIKES UnLike

I'm in Enterprise manager and am looking at an expanded table list for a database.

There is a table in particular I'm looking at for which I would like to know if there are any other linked tables.

Can this be done?

Thanks in advance

 Tags:

   Report

1 ANSWERS


  1. The Design Table dialogue will show you any foreign key constraints on the table. This assumes foreign keys have been set up. If they haven't, there isn't any possible way for the database to show the relationship between tables because it doesn't know what they are.

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.