HOW TO GET ALL TABLE SIZE

CREATE TABLE #TableSize
(TableName VARCHAR(100),
Records BIGINT,
Reserved VARCHAR(10),
Data VARCHAR(10),
Index_Size VARCHAR(10),
UnUsed VARCHAR(10))
GO
INSERT #TableSize
EXEC('sp_msforeachtable "sp_spaceused ''?''"')
GO
SELECT TableName,Records,Reserved,Data,Index_Size,UnUsed FROM #TableSize
GO
DROP TABLE #TableSize