数据库中所有表的行数

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

posted @ 2014-10-25 22:33  kuailewangzi1212  阅读(321)  评论(0编辑  收藏  举报