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:
Join the conversation! Your thoughts help the community grow.