我只会这样做。。select count(*) from 表1 union select count(*) from 表2 union .....类推
select a.name,b.rows from sysobjects ainner join sysindexes b on a.id=b.idwhere a.type='u' and b.indid in (0,1)
