SELECT name FROM sysobjects so 
INNER JOIN sysreferences sr ON sr.constid=so.id
WHERE so.xtype='F'
AND parent_obj=(SELECT id FROM sysobjects WHERE name='ParentTable')
AND sr.rkeyid=(SELECT id FROM sysobjects WHERE name='ChildTable')