使用当前库
use DATABASENAME
列出当前库下所以的表名
Select Name FROM SysObjects Where XType='U'
编写查询sql,导出一个查询所以库统计的sql
select 'select count(*),'+name+' as name
from "'+name+'" union all' from sysobjects
where type='u' order by name
去掉最后一个union all
查询结果就出来啦