SQL Server finds all tables for which a foreign key is referenced

Directly on the code:

1 SELECTOsub.name as [child table name] ,2Fk.name as [FOREIGN Key Name] ,3Subcol.name as [child table column name] ,4Omain.name as [Primary Table name] ,5Maincol.name as [primary table column name]6  fromSys.foreign_keys FK7         JOINSys.all_objects osub on(fk.parent_object_id=Osub.object_id )8         JOINSys.all_objects Omain on(fk.referenced_object_id=Omain.object_id )9         JOINSys.foreign_key_columns Fkcols on(FK.object_id =fkcols.constraint_object_id)Ten         JOINSys.columns Subcol on(Osub.object_id =Subcol.object_id One                                       andfkcols.parent_column_id=subcol.column_id A                                    ) -         JOINSys.columns Maincol on(Omain.object_id =Maincol.object_id -                                        andfkcols.referenced_column_id=maincol.column_id the                                     ) - WHEREFk.name like @FOREIGN KEY;

@FOREIGN KEY

SQL Server finds all tables for which a foreign key is referenced