sql server中所有的外键信息

select   b.name   as   constname  
  ,c.name   as   ForeignTable  
  ,d.name   as   ForeignCol  
  ,e.name   as   refTable  
  ,f.name   as   refCol  
  from   sysforeignkeys   a  
  inner   join   sysobjects   b   on   a.constid=b.id  
  inner   join   sysobjects   c   on   a.fkeyid=c.id  
  inner   join   syscolumns   d   on   a.fkeyid=d.id   and   a.fkey=d.colid  
  inner   join   sysobjects   e   on   a.rkeyid=e.id  
  inner   join   syscolumns   f   on   a.rkeyid=f.id   and   a.rkey=f.colid