Physical size of MS SQL Table.

Question

Hello, How to find what the physical size of table in MS Sql 2005? Is it possible using sql query or not? Thanks.

Answer 1

Try the stored procedure:

exec sp_spaceused TableName

For all tables you could use:

exec sp_Msforeachtable 'exec sp_spaceused'

Answer 2

You can use the sp_spaceused system procedure:

EXECUTE sp_spaceused 'YourTable'

Answer 3

SELECT table_schema, table_name, ROUND(data_length/1024/1024,2) total_size_mb FROM information_schema.tables WHERE table_name = 'emp_master' AND table_schema = 'emp_database';