Space used by tables

spaceused.sql

declare @SpaceUsed table (TableName sysname, NumRows bigint, ReservedSpace varchar(50), DataSpace varchar(50), IndexSize varchar(50), UnusedSpace varchar(50)) 

declare @str varchar(500)
set @str =  'exec sp_spaceused ''?'''
insert into @SpaceUsed 
exec sp_msforeachtable @command1=@str

select TableName,
       FORMAT(CAST(NumRows as bigint), 'N0') as NumRows,
       FORMAT(CAST(REPLACE(ReservedSpace, ' KB', '') as bigint), 'N0') + ' KB' as ReservedSpace,
       FORMAT(CAST(REPLACE(DataSpace, ' KB', '') as bigint), 'N0') + ' KB' as DataSpace,
       FORMAT(CAST(REPLACE(IndexSize, ' KB', '') as bigint), 'N0') + ' KB' as IndexSize,
       FORMAT(CAST(REPLACE(UnusedSpace, ' KB', '') as bigint), 'N0') + ' KB' as UnusedSpace
  from @SpaceUsed
 --order by TableName
 order by CAST(REPLACE(DataSpace, ' KB', '') as bigint) desc