SQL query specifies table FOREIGN KEY constraints

Query specifies table foreign KEY constraints
Selecta.name as constraint name, object_name (b.parent_object_id) as foreign key table, d.name as foreign key column, object_name (b.referenced_object_id) As main health table, C.name as primary key column from Sys.foreign_keys Ainner join Sys.foreign_key_columns B on A.object_id=b.constraint_object_idinner join Sys.columns C on b.parent_object_id=c.object_id and b.parent_column_id=c.column_id inner joins sys.columns D on B.referenc ed_object_id=d.object_id and b.referenced_column_id=d.column_id where object_name (b.referenced_object_id) = ' table name to query ' ;

SQL query specifies table FOREIGN KEY constraints