Aug 8, 2012

Display size of tables in SQL Server

A very simple query but yet so useful in getting the information of tables size in your database:

USE [yourdbname]
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

No comments:

Post a Comment