SQL Server Get size of all tables in database

1. Go to SQL Server Management Studio

2. Go to Object explorer => Databases

3. Right click on the database which you want to get size of each table

4. Navigate to Reports => Standard Reports => Disk Usage By Table

5. It will generate report like below...