摘要: 返回表名、索引名和行数SELECT object_name(i.object_id) as objectName, i.[name] as indexName, sum(p.rows) as rowCntFROM sys.indexes iINNER JOIN sys.partitions pON i.object_id = p.object_idAND i.index_id = p.index_idWHERE i.object_id = object_id('dbo.Meeting')AND i.index_id = 1GROUP BY i.object_id, i.index_id, i 阅读全文
posted @ 2010-12-20 14:47 zping 阅读(1683) 评论(0) 推荐(0) 编辑
点击右上角即可分享
微信分享提示