create table #t(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20))
exec sp_MSforeachtable "insert into #t exec sp_spaceused '?'"
select * from #t
order by rows desc
drop table #t
查询所有表大小
最新推荐文章于 2024-01-16 08:48:55 发布