SQL Server 批量查 数据库所有表的主键
摘要：
SELECTa.name AS '表',e.name AS '主键字段'FROM sysobjects AS a --对象表，结合a.xtype='U'条件，查用户表LEFT JOIN sysobjects AS b --对象表，结合b.xtype='PK'条件，查主键约束ON a.id=b.parent_obj LEFT JOIN sysindexes AS c --索引表，根据（主键）约束名称匹配，查对应字段索引ON a.id=c.id AND b.name=c.nameLEFT JOIN sysindexkeys AS d 阅读全文
posted @ 2013-07-31 12:57 Yongze 阅读(1050) 评论(0) 推荐(0) 编辑
