檢視SQL SERVER表的空間使用情況，特此記錄：

create table #tmp_1 (name varchar(50),rows int,reserved varchar(50),
data varchar(50),index_size varchar(50),unused varchar(50))

insert into #tmp_1 (name,rows,reserved,
data,index_size,unused)
exec sp_MSforeachtable @command1="exec sp_spaceused '?'"

select * from #tmp_1

select name,rows,CONVERT(int, REPLACE(reserved,' KB','')) reserved,
CONVERT(int,REPLACE(data,' KB','')) data,
CONVERT(int,REPLACE(index_size,' KB','')) index_size,
CONVERT(int,REPLACE(unused,' KB','')) unused
into #tmp_2
from #tmp_1

select * from #tmp_2

select COUNT(*),SUM(reserved),SUM(data),SUM(index_size),SUM(unused) from #tmp_2

檢視SQL SERVER表的空間使用情況

相關文章