一个查询数据库中所有表的空间占用情况的存储过程

不知道是否还有更好的获取方法。

CREATE PROCEDURE L_spTableSpaceUsed
 AS
SET NOCOUNT ON

DECLARE @Result TABLE
(
    TableName VARCHAR(64)
    , [Rows] INT
    , Reserved VARCHAR(64)
    , [Data] VARCHAR(64)
    , Index_Size VARCHAR(64)
    , Unused VARCHAR(64)
)

DECLARE @TableName VARCHAR(64)

DECLARE curTable CURSOR FAST_FORWARD FOR
    SELECT [Name] FROM Sys.Tables WHERE [Name] NOT LIKE 'DatabaseSchema%'
    
OPEN curTable
FETCH NEXT FROM curTable INTO @TableName
WHILE @@Fetch_Status = 0
BEGIN
    INSERT INTO @Result
    EXEC sp_SpaceUsed @TableName
    FETCH NEXT FROM curTable INTO @TableName
END
CLOSE curTable
DEALLOCATE curTable

SELECT *
FROM @Result
ORDER BY Cast(Left([Data], Len([Data]) -2) AS INT) DESC

SET NOCOUNT OFF