22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT a.*, b.name AS refTable,c.name AS parTable,d.name AS subCol,e.name AS parCol,'0' AS chk
FROM sys.foreign_key_columns a
LEFT JOIN sys.objects b ON b.object_id=a.referenced_object_id
LEFT JOIN sys.objects c ON c.object_id=a.parent_object_id
LEFT JOIN sys.columns d ON a.referenced_object_id=d.object_id AND a.referenced_column_id=d.column_id
LEFT JOIN sys.columns e ON a.parent_object_id =e.object_id AND a.parent_column_id=e.column_id
WHERE a.parent_object_id=OBJECT_ID('stuInfo')
最后结果如图
好像父子关系,PD中与SQL中是不是反过来了,还是我的代码有什么问题