34,588
社区成员
发帖
与我相关
我的任务
分享
select
object_name(a.rkeyid) as [主键表名],
b.name as [主键列名],
object_name(a.fkeyid) as [外键表名],
c.name as [外键列名]
from dbo.sysforeignkeys a
join dbo.syscolumns b
on b.colid = a.rkey
and b.id = a.rkeyid
join dbo.syscolumns c
on c.colid = a.fkey
and c.id = a.fkeyid