SQL Server/T-SQL Tutorial/System Functions/sp spaceused

Report on each table using sp_spaceused

   <source lang="sql">

3> 4> DECLARE @AWTables TABLE (SchemaTable varchar(100)) 5> DECLARE @TableName varchar(100) 6> 7> WHILE (SELECT COUNT(*) FROM @AWTables)>0 8> BEGIN 9> SELECT TOP 1 @TableName = SchemaTable FROM @AWTables ORDER BY SchemaTable 10> EXEC sp_spaceused @TableName 11> DELETE @AWTables WHERE SchemaTable = @TableName 12> END 13> 14> WHILE (1=1) 15> BEGIN 16> PRINT "1 --- 1" 17> IF 1=1 18> BEGIN 19> PRINT "Break up now." 20> BREAK 21> END 22> ELSE 23> BEGIN 24> CONTINUE 25> END 26> END 27> GO 1 --- 1 Break up now.</source>

sp_spaceused reviews the space used by a table in a database.

   <source lang="sql">

You can also displace the disk space reserved and used by an entire database. The syntax is sp_spaceused [tablename[,@updateusage={TRUE�FALSE}]]</source>