常用sql 查询
IF OBJECT_ID('TMP_TABLE_20161023') IS NOT NULL
DROP TABLE TMP_TABLE_20161023
GO
CREATE 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.前缀,免得报错提示存储过程不存在
GO
SELECT *
FROM TMP_TABLE_20161023
ORDER BY REPLACE(data_size,'KB','')+ 0 DESC
GO