The below SQL script will return a list of tables in a database along with the table sizes in MB.

​You will get a report like the below;

SQL Report the disk size each table is using in a database

Author: Phil Eddies

I am an IT Operations Manager, managing all aspects of the IT infrastructure and service for a mid sized UK based company. I have been working full time in IT since 2001 in 1st to 3rd line and System Administration roles. MCSA, MCSE, CCNA, Citrix CCA