新建零时表TB_TEMP_SPACE,将某个数据库中的表都查出来,库名,行数,大小,索引大小
“`
IF OBJECT_ID(‘tempdb..#TB_TEMP_SPACE’) IS NOT NULL DROP TABLE #TB_TEMP_SPACE
GO
CREATE TABLE #TB_TEMP_SPACE(
NAME VARCHAR(500)
,ROWS INT
,RESERVED VARCHAR(50)
,DATA VARCHAR(50)
,INDEX_SIZE VARCHAR(50)
,UNUSED VARCHAR(50)
)
GO
SP_MSFOREACHTABLE ‘INSERT INTO #TB_TEMP_SPACE exec sp_spaceused ”?”’
GO
SELECT *
FROM #TB_TEMP_SPACE
ORDER BY REPLACE(DATA,’KB’,”) DESC
GO