下記のクエリを実行
CREATE TABLE #temp ( [TableName] SYSNAME, [rows] BIGINT, [reserved] VARCHAR(25), [data] VARCHAR(25), [index_size] VARCHAR(25), [unused] VARCHAR(25) ); INSERT INTO #temp EXEC sp_MSforeachtable @command1 = "sp_spaceused '?'" SELECT * FROM #temp GO
コメント