T-SQL: Show sizes of all tables in a database

You can use the t-sql code below in order display the size of each table in a specific database.

use MY_DATABASE_NAME
go
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
go