列举某个表作为主键被别人引用的外键

 select fk.name fkname , ftable.name ftablename, cn.name fkcol, rtable.name ftablename from sysforeignkeys
  join sysobjects fk
    on sysforeignkeys.constid = fk.id
  join sysobjects ftable
    on sysforeignkeys.fkeyid = ftable.id
  join sysobjects rtable
    on sysforeignkeys.rkeyid = rtable.id
  join syscolumns cn
    on sysforeignkeys.fkeyid = cn.id and sysforeignkeys.fkey = cn.colid
where rtable.name='Suppliers'