sqlserver外來鍵

A為主表B為子表

 

select t1.name,t2.rtableName,t2.name
from
(select col.name, f.constid as temp
from syscolumns col,sysforeignkeys f
where f.fkeyid=col.id
and f.fkey=col.colid
and f.constid in
( select distinct(id)
from sysobjects
where OBJECT_NAME(parent_obj)='B'
and xtype='F'
)
) as t1 ,
(select OBJECT_NAME(f.rkeyid) as rtableName,col.name, f.constid as temp
from syscolumns col,sysforeignkeys f
where f.rkeyid=col.id
and f.rkey=col.colid
and f.constid in
( select distinct(id)
from sysobjects
where OBJECT_NAME(parent_obj)='B'
and xtype='F'
)
) as t2
where t1.temp=t2.temp

 

exec     sp_helpconstraint  B

 

 

exec sp_fkeys @pktable_name = 'A' ,@pktable_owner = 'DBO'

 

select * from sys.foreign_keys
where OBJECT_NAME(referenced_object_id)='A'