导航

SQL统计表行数

Posted on 2012-05-22 08:52  yiyishuitian  阅读(496)  评论(0)  编辑  收藏  举报

最好先

DBCC UPDATEUSAGE


SELECT o.name AS "Table Name", i.rowcnt AS "Row Count" 

FROM sysobjects o, sysindexes i 

WHERE i.id = o.id AND i.indid IN(0,1) AND o.xtype = 'u' --只统计用户表 

AND o.name <> 'sysdiagrams' ORDER BY i.rowcnt DESC --按行排降序