sqlserver获取表外键的SQL语句

select t1.name as clmnName, t2.rtableName as fkTbl,
t2.name as fkClmn from (select col.name, f.constid as temp  from syscolumns col,sysforeignkeys f  where f.fkeyid=col.id  and f.fkey=col.colid  and f.constid in 
( select distinct(id)     from sysobjects    where OBJECT_NAME(parent_obj)='表名'
    and xtype='F'   )  ) as t1 , (
select OBJECT_NAME(f.rkeyid) as rtableName,col.name, f.constid as temp  from
syscolumns col,sysforeignkeys f 
where f.rkeyid=col.id  and f.rkey=col.colid 
and f.constid in  ( select distinct(id)    from sysobjects  
 where OBJECT_NAME(parent_obj)='表名'    and xtype='F'  ) )
 as t2 where t1.temp=t2.temp