Finding Related Tables

[arnoldpinto84]

Hi, Could some1 help me with a query which will allow me to get a list of related tables for a particular table. for eg. suppose the user selects 'Product' table , i need a list of tables that are related to the product table Thanks.

[joemonvarghese]

hi this qry will give u all the related tables of table 'Product' select t.name from sysobjects t,syscolumns c where t.id=c.id and c.name in (select c.name from sysobjects t,syscolumns c where t.id=c.id and t.name='Product')