Find the Byte Size Of All tables in your SQL Server DB

Created by
Tuesday, August 16, 2016

Using the free Northwind database from Microsoft.

With this query we query the Byte size of each table in our database.

SELECT sob.name AS Table_Name,  
SUM(sys.length) AS [Size_Table(Bytes)]  
FROM sysobjects sob, syscolumns sys  
WHERE sob.xtype='u' AND sys.id=sob.id  
GROUP BY sob.name 

0
Rating
1 2 3 4 5

Save

Saved

Report

Reported
Reasons
Cancel
0 comments