create table tmp
(
name varchar(50),
rowscount int,
reserved varchar(50),
data varchar(50),
index_size varchar(50),
unused varchar(50)
);
insert tmp(name, rowscount, reserved, data, index_size, unused)
exec sp_MSforeachtable @command1="sp_spaceused '?'";
select * from tmp where name <> 'tmp' order by name
drop table tmp ;
SQL获取指定数据库所有表的物理大小
最新推荐文章于 2021-04-03 21:08:00 发布