数据库查询各表占用空间

wbv123

/ 查询各表所占表空间 /
if object_id(‘tempdb..#test’) is not null drop table #test
GO
create table #test(
name varchar(50),
rows int,
reserved varchar(20),
data varchar(20),
index_size varchar(20),
unused varchar(20)
)
insert into #test
exec sp_MSforeachtable “exec sp_spaceused ‘?'”

select cast(replace(reserved,’KB’,”) as int) / 1024 / 1024 ,* from #test order by cast(replace(reserved,’KB’,”) as int) desc

–truncate table t_ws_tranlist –清表

/ 查询各表所占表空间 /
if object_id(‘tempdb..#test’) is not null drop table #test
GO
create table #test(
name varchar(50),
rows int,
reserved varchar(20),
data varchar(20),
index_size varchar(20),
unused varchar(20)
)
insert into #test
exec sp_MSforeachtable “exec sp_spaceused ‘?'”

select cast(replace(reserved,’KB’,”) as int) / 1024 / 1024 ,* from #test order by cast(replace(reserved,’KB’,”) as int) desc

–truncate table t_ws_tranlist –清表