How to find the size of a table in SQL?

Question

How to find the size of a table in SQL?

Answer 1

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