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

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.Hi
Look at INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS.
John
<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.