How to retrieve a result set of all tables in the DB with their disk space usage

with this transact sql script:

create table #Temp (
          name nvarchar(128),
          [rows] char(11),
          reserved varchar(18),
          data varchar(18),
          index_size varchar(18),
         unused varchar(18)
)

insert into #Temp
exec sp_msforeachtable ‘sp_spaceused ”?”’

select * from #Temp order by cast(replace(reserved,’ kb’,”) as int) desc