• simpler statement

    select object_name(referenced_object_id) as PrimaryKeyTable

    ,object_name(parent_object_id) as ForeignKeyTable

    ,*

    fromsys.foreign_keys

    whereobject_name(referenced_object_id) like '%mySearchedPrimaryKeyTable%'

    order by object_name(referenced_object_id)

    ,object_name(parent_object_id)