Space Usage of ALL TABLES in the Current Database

Getting the Size/Space of ALL TABLES in the Current Database

List the space used in all tables within the currently connected database.

It takes all the tables from the currently connected database and displays the size of the table in the result window.

exec sp_msforeachtable "sp_spaceused '?'"

Just drop the query and run it. J