第一列就是表名,第二列就是外键的列名,第三列就是关联名
select a.name as chdt,b.name as col,d.name as ref from sysobjects a,syscolumns b,sysobjects d,sysforeignkeys e
where a.id=e.fkeyid
and b.colid=e.fkey
and b.id=a.id
and d.id=e.constid
and a.name='表名'
select a.name as chdt,b.name as col,d.name as ref from sysobjects a,syscolumns b,sysobjects d,sysforeignkeys e
where a.id=e.fkeyid
and b.colid=e.fkey
and b.id=a.id
and d.id=e.constid
and a.name='表名'
sp_fkeys @fktable_name = '外键表名'
具体请楼主参考sp_fkeys帮助.