テーブルサイズを確認するSQLクエリ

SQL Server

CREATE TABLE #SPACES
([name][sysname],[rows][bigint],[reserved][varchar](18),
[data][varchar](18),[index_size][varchar](18),[unused][varchar](18))
DECLARE @table sysname

DECLARE C CURSOR LOCAL FOR SELECT name FROM sysobjects WHERE XTYPE='U'
OPEN C
FETCH NEXT FROM C INTO @table
WHILE (@@FETCH_STATUS=0)
BEGIN
INSERT INTO #SPACES EXEC sp_spaceused @table FETCH NEXT FROM C INTO @table END CLOSE C DEALLOCATE C

SELECT * FROM #SPACES
ORDER BY name

DROP TABLE #SPACES