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