sp_spaceused reviews the space used by a table in a database. : sp_spaceused « System Functions « SQL Server / T-SQL Tutorial






You can also displace the disk space reserved and used by an entire database. 
The syntax is 
sp_spaceused [tablename[,@updateusage={TRUEFALSE}]]
25.56.sp_spaceused
25.56.1.sp_spaceused reviews the space used by a table in a database.
25.56.2.Report on each table using sp_spaceused