查询数据库所有表的记录数

SQL server

 

select o.name,i.rows
from sysobjects o,sysindexes i
where o.xtype='U'
and o.Id=i.Id
and i.Indid<2
order by i.rows desc