使用了微软提供的不公开的存储过程sp_MSforeachtable
 

  CREATE TABLE #temp  (   TableName NVARCHAR (128),    RowsCnt VARCHAR (11),   ReservedSpace VARCHAR(18),   DataSpace VARCHAR(18),   CombinedIndexSpace VARCHAR(18),   UnusedSpace VARCHAR(18)   )      EXEC sp_MSforeachtable'INSERT INTO #temp (TableName, RowsCnt, ReservedSpace,DataSpace, CombinedIndexSpace, UnusedSpace) EXEC sp_spaceused ''?'', FALSE'     SELECT TableName, RowsCnt,ReservedSpace, DataSpace, CombinedIndexSpace, UnusedSpace   FROM #temp   ORDER BY TableName     DROP TABLE #temp

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注