--查看指定表
select * from sysobjects where parent_obj in(
select id from sysobjects where name='表名')
and xtype='PK'
--查看所有表
select * from sysobjects where xtype='PK'

------解决方案--------------------

select Object_name(parent_obj) 表名,Name 外键名
From sysObjects a
where xtype='f'

------解决方案--------------------
SQL code
select * from sysobjects where xtype='PK'