22,300
社区成员




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')
最后结果如图