查询当前数据库中表的存储信息

declare  @table_spaceused table

(name   nvarchar(100)

,rows   int

,reserved   nvarchar(100)

,data   nvarchar(100)

,index_size nvarchar(100)

,unused nvarchar(100)

)

 

insert into @table_spaceused 

(name,rows,reserved,data,index_size,unused )

exec sp_MSforeachtable 

@command1='exec sp_spaceused ''?'''

 

select * from @table_spaceused