查看mysql&sqlserver的一个数据库中各个表的数据量

mysql查看v3x数据库的表：

use information_schema;

select table_name,table_rows from tables
where TABLE_SCHEMA = 'v3x'
order by table_rows desc;



sqlserver：

SELECT
o.name, i. ROWS
FROM sysobjects o, sysindexes i
WHERE o.id = i.id  AND o.Xtype = 'U' AND i.indid < 2
ORDER BY o.name;


原文：http://sky302761277.blog.163.com/blog/static/198342213201422043113162/