sqlserver 查看表所占磁盘空间

CREATE TABLE tb_SpaceInfoTable
(
   ID int identity(1,1),
   name sysname,
   rows char(11),
   reserved varchar(18),
   data varchar(18),
   index_size varchar(18),
   unused varchar(18)
)
GO

EXEC SP_MSFOREACHTABLE
@COMMAND1 = 'INSERT INTO tb_SpaceInfoTable(name,
                                           rows,
                                           reserved,
                                           data,
                                           index_size,
                                           unused)
              EXEC SP_SPACEUSED ''?'''
GO

SELECT * FROM tb_SpaceInfoTable order by cast(replace(data,' KB','') as decimal(28,0)) desc
GO