How to find the size of a table in SQL?

SQL Server:-

sp_spaceused 'TableName'

Or in management studio:
Right Click on table -> Properties -> Storage

MySQL:-

SELECT table_schema, table_name, data_length, index_length FROM information_schema.tables

Sybase:-

sp_spaceused 'TableName'

Oracle:-
how-do-i-calculate-tables-size-in-oracle

Leave a Comment