select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
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
救命啊!!!
http://community.csdn.net/Expert/topic/4303/4303421.xml?temp=.1166498
,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