感谢你的回答,你的语句虽好,不过有点不足:无法看到这些外键存在于哪个表。昨天我自己写了一个,拿出来给大家参考下: ;WITH id AS ( SELECT fk.constraint_object_id , fk.parent_object_id FROM sys.foreign_key_columns fk WHERE fk.referenced_object_id = ( SELECT object_id FROM sys.tables WHERE name = 'person' ) ) SELECT so.NAME , st.NAME FROM sys.objects so JOIN id ON so.object_id = id.constraint_object_id JOIN sys.tables st ON id.parent_object_id = st.object_id
;WITH id
AS ( SELECT fk.constraint_object_id ,
fk.parent_object_id
FROM sys.foreign_key_columns fk
WHERE fk.referenced_object_id = ( SELECT object_id
FROM sys.tables
WHERE name = 'person'
)
)
SELECT so.NAME ,
st.NAME
FROM sys.objects so
JOIN id ON so.object_id = id.constraint_object_id
JOIN sys.tables st ON id.parent_object_id = st.object_id