查看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.idAND o.Xtype = 'U' AND i.indid < 2
ORDER BY o.name;
原文：http://sky302761277.blog.163.com/blog/static/198342213201422043113162/
页:
[1]