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'

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/756652/viewspace-710473/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/756652/viewspace-710473/