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

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

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