DB2:
call get_dbsize_info(?,?,?,-1) 查询之后显示字节数(注意转换)
sqlserver:
exec sp_spaceused (查询数据库大小)
exec sp_spaceused '表名';(查询数据库中指定表大小)
mysql:
select TABLE_NAME, concat(truncate(data_length/1024/1024,2),' MB') as data_size, concat(truncate(index_length/1024/1024,2),' MB') as index_size from information_schema.tables where TABLE_SCHEMA = 'jz-project' group by TABLE_NAME order by data_length desc;