Below is a script I use to determine table size. Basically, it walks through the user databases and for each table. The information is converted in GB. It’s a pretty simple use of MS sp_spaceused with sp_msforeachtable. More info on sp_spaceused.
Full script, below. Download script here.