SQL Server查询数据库中表使用空间信息实现脚本

使用了微软提供的不公开的存储过程sp_MSforeac hta ble
 

CREATE TABLE #temp
(
 TableName NVARCHAR (128),
  RowsCnt VARCHAR (11),
 ReservedSpace VARCHAR(18),
 DataS  编程  pace VARCHAR(18),
 CombinedIndexSpace VARCHAR(18),
 UnusedSpace VARCHAR(18)
 )
 
 EXEC sp_MSf android oreachtable'INSERT INTO #temp (TableName, RowsCnt, ReservedSpace,Dat ASP ace, CombinedIndexSpace, UnusedS  javascript  pace  编程客栈  ) EXEC sp_spa http://www.cppcns.com ceused ''?'', FALSE'
 
SELECT TableName, RowsCnt,ReservedSpace, DataSpace, CombinedIndexSpace, UnusedSpace
 FROM #temp
 ORDER BY TableName
 
DROP TABLE #temp

查看更多关于SQL Server查询数据库中表使用空间信息实现脚本的详细内容...