CREATE TABLE #T(NAME VARCHAR(255), ROWS BIGINT, RESERVED VARCHAR(20), DATA VARCHAR(20), INDEX_SIZE VARCHAR(20), UNUSED VARCHAR(20))
EXEC SP_MSFOREACHTABLE "INSERT INTO #T EXEC SP_SPACEUSED '?'"
SELECT * FROM #T ORDER BY ROWS DESC
以上语句为查询所有表物理大小语句