How to report the space used for each table in a SQL server DB?

USE [MyDatabaseName]

GO

sp_msforeachtable 'exec sp_spaceused [?]'

GO