查询当前数据库中所有表名 以及表对应的行数

select "表名"= convert (varchar (50), o.name), "行数"=i.rows
from sysobjects o (nolock), sysindexes i (nolock)
where o.type = 'U' and o.id = i.id and i.indid in (0,1)
order by rows desc ,o.name