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
Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*