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 --按行排降序 
 
COMPUTE SUM(i.rowcnt), count(o.name); --汇总行数，表数 
GO 

优质内容筛选与推荐>>
1、拾色器前端工具
2、smartClient 3--布局
3、如何做好垂直搜索
4、Pile 0003: RSSI
5、springMVC 注解 controller层的优化