直接选中你要查的数据库,
然后执行下面的语句
一、MSSQL
select b.name,a.row_count from sys.dm_db_partition_stats a,
sys.objects b
where a.object_id=b.object_id
and a.index_id<=1
and b.type='U' ORDER BY row_count
二、MYSQL用下面的
USE information_schema;
SELECT table_name,table_rows FROM TABLES
WHERE TABLE_SCHEMA = 'ukefu41'
ORDER BY table_rows DESC;