select object_name(A.parent_obj) as 表名
,col_name(A.parent_obj,B.fkey) as 列名
,object_name(B.rkeyid) as 引用表名
,col_name(B.rkeyid,B.rkey) as 引用列名
from sysobjects A
join sysforeignkeys B on A.id=B.constid
where A.name='外键名称'
,col_name(A.parent_obj,B.fkey) as 列名
,object_name(B.rkeyid) as 引用表名
,col_name(B.rkeyid,B.rkey) as 引用列名
from sysobjects A
join sysforeignkeys B on A.id=B.constid
where A.name='外键名称'
,col_name(A.parent_obj,B.fkey) as 列名
,object_name(B.rkeyid) as 引用表名
,col_name(B.rkeyid,B.rkey) as 引用列名
from sysobjects A
join sysforeignkeys B on A.id=B.constid
where A.name='外键名称'