Find Byte Size of Tables in Database

This blog explains how to retrieve the byte sizes of tables that are present in current database. Use Below query to find out the size of tables.

 

Query:

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

Result: