查询数据库表所占空间

最新推荐文章于 2024-11-12 20:35:48 发布

aureate820

最新推荐文章于 2024-11-12 20:35:48 发布

阅读量363

点赞数 2

文章标签：数据库 insert object table

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 ' , '' ) + 0 DESC GO