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:
![]()