How to get all the foreign key table referenced with Master table

Question

I have a Product table as parent table . How can I get all the related tables with Product with foreing key reference . Please can you help

Answer 1

Hi，@Polachan Paily

Try the following code:

select  t.name as TableWithForeignKey, fk.constraint_column_id as FK_PartNo, c.name as ForeignKeyColumn   
from  sys.foreign_key_columns as fk  
inner join sys.tables as t on fk.parent_object_id = t.object_id  
inner join sys.columns as c on fk.parent_object_id = c.object_id   
                                        and  fk.parent_column_id = c.column_id  
where  fk.referenced_object_id = (select object_id    
                                                      from sys.tables   
                                                      where name = ' Product')----add your tablename  

order by TableWithForeignKey, FK_PartNo  

IF you want to get useful information by simple code,you could try it:

EXEC sp_fkeys ' Product'  

Best regards,
Bert Zhou

Answer 2

In SSMS rigth-mouse click on the table => Show dependencies.