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...