SQLServer:
USE 数据库名
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC
Oracle:
DBA权限下可以查询dba_tables,里面有个num_rows列
select table_name,num_rows from dba_tables;
条件可以根据自己需要来加
不过,num_rows列并不是事实更新的,好像是1小时更新一次,查新之前最好先ANALYZE下
analyze table xxx compute statistics;