代碼: 選擇全部
create table #used_table
( name nvarchar(255),
rows int,
reserved nvarchar(255),
data nvarchar(255),
index_size nvarchar(255),
unused nvarchar(255)
)
EXEC sp_MSforeachtable
@command1 = "insert into #used_table exec sp_spaceused '?'"
select * from #used_table
drop table #used_table
代碼: 選擇全部
create table #used_table
( name nvarchar(255),
rows int,
reserved nvarchar(255),
data nvarchar(255),
index_size nvarchar(255),
unused nvarchar(255)
)
EXEC sp_MSforeachtable
@command1 = "insert into #used_table exec sp_spaceused '?'"
select * from #used_table
create table #used_table2
( name nvarchar(255),
rows int,
reserved_KB int,
data_KB int,
index_size_KB int,
unsed_KB int
)
insert into #used_table2 select name, rows, replace(reserved, ' KB', ''), replace(data, ' KB', ''), replace(index_size, ' KB', ''), replace(unused, ' KB', '') from #used_table
select * from #used_table2
drop table #used_table
drop table #used_table2