日期:2014-05-18 浏览次数:20404 次
--查看指定表 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'
------解决方案--------------------
select * from sysobjects where xtype='PK'