导航

SQLServer、MySQL、Oracle如何查看所有表的条数

Posted on 2018-12-18 17:02  许爱琪  阅读(279)  评论(0编辑  收藏  举报

SQLServer:

 

create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20),spaces int)
exec sp_MSforeachtable "insert into #t(name,rows,reserved,data,index_size,unused) exec sp_spaceused '?'"
UPDATE #t SET spaces = CAST(REPLACE(REPLACE(reserved,'KB',''),' ','') AS INT)/1024.0
select * from #t ORDER BY rows DESC

 

 

MySQL:

use information_schema;

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

 

Oracle:

藐视只能count所有表,union all拼接了