sql 表占用空间查询

常用sql 查询

IF OBJECT_ID('TMP_TABLE_20161023') IS NOT NULL    DROP TABLE TMP_TABLE_20161023GOCREATE TABLE TMP_TABLE_20161023(table_name VARCHAR(500),row_counts INT       --记录数,reserved VARCHAR(50),data_size VARCHAR(50),index_size VARCHAR(50),free VARCHAR(50))GO sys.sp_MSforeachtable  'INSERT INTO TMP_TABLE_20161023 exec sp_spaceused ''?''' --加上sys.前缀，免得报错提示存储过程不存在GOSELECT *  FROM TMP_TABLE_20161023 ORDER BY REPLACE(data_size,'KB','')+ 0 DESCGO