已知sqlserver2000的一张表存在主键,怎么遍历与其建立外键关系的表

--列分别是:外键id,主表名称，主表字段，外键字段编号，外键表名称，外键表列
select a.constid,c.name as rtname,e.name as rcname,a.keyno, b.name as ftname,d.name as fcname
from sysforeignkeys a inner join sysobjects b on a.fkeyid = b.id
inner join sysobjects c on a.rkeyid = c.id
inner join syscolumns d on b.id = d.id and a.fkey = d.colid
inner join syscolumns e on c.id = e.id and a.rkey = e.colid
--where c.name = '表名' --如果需要查某个表的,就把注释去掉