SELECT *
FROM
sys.foreign_keys
WHERE
referenced_object_id =
object_id('User')
n
OR
EXEC sp_fkeys 'User'
n
OR
SELECT OBJECT_NAME(parent_object_id) AS Parent_Object,
OBJECT_NAME(referenced_object_id) AS Rreferenced_Object,
name
FROM
sys.foreign_keys
WHERE parent_object_id
= object_id('User')