select fk.name 外键约束名 ,
ftable.name 表名,
cn.name 列名,
st.name 域,
rtable.name 参照表名
from sysforeignkeys sfk
join sysobjects fk on sfk.constid = fk.id
join sysobjects ftable on sfk.fkeyid = ftable.id
join sysobjects rtable on sfk.rkeyid = rtable.id
join syscolumns cn on sfk.fkeyid = cn.id and sfk.fkey = cn.colid
join systypes st on cn.[xtype]=st.[xtype]