数据库中所有表的行数
select a.name,b.rows from sysobjects a,sysindexes b
where a.id=b.id
and xtype='U' AND (b.indid IN (0, 1))-- and rows>=8575
order by b.rows desc
select a.name,b.rows from sysobjects a,sysindexes b
where a.id=b.id
and xtype='U' AND (b.indid IN (0, 1))-- and rows>=8575
order by b.rows desc