select b.name as constname
,c.name as ForeignTable
,d.name as ForeignCol
,e.name as refTable
,f.name as refCol
from sysforeignkeys a
inner join sysobjects b on a.constid=b.id
inner join sysobjects c on a.fkeyid=c.id
inner join syscolumns d on a.fkeyid=d.id and a.fkey=d.colid
inner join sysobjects e on a.rkeyid=e.id
inner join syscolumns f on a.rkeyid=f.id and a.rkey=f.colid
sql server中所有的外键信息
最新推荐文章于 2021-06-10 16:48:08 发布