**fetch the related tables of a particular table**

fetch the related tables of a particular table

microsoft.public.sqlserver.programming

18 Mar 2006 7:53 AM

R-M

Hi

I'm working with SQL server 2000, and I want to know how can I find the
list of tables which have relation to a particular table. in another word,
would it be possible to fetch the name of those tables by a simple Sql
statement?

Any help would be greatly appreciated.

18 Mar 2006 3:50 PM

John Bell

Hi

Look at INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS.

John

Show quote

<R> wrote in message news:ops6lmu3xamw7tkz@system109.parskhazar.net...
> Hi
>
> I'm working with SQL server 2000, and I want to know how can I find the
> list of tables which have relation to a particular table. in another word,
> would it be possible to fetch the name of those tables by a simple Sql
> statement?
>
> Any help would be greatly appreciated.