<p>I think most people know how to do this via the GUI (right click table, properties), but doing this in T-SQL totally rocks.</p>

[{'answer_id': 2715, 'author': 'Nathan Bedford', 'author_id': 434, 'author_profile': 'https://Stackoverflow.com/users/434', 'pm_score': 5, 'selected': True, 'text': "<pre>\nCREATE TABLE #tmpSizeChar (\n     table_name sysname ,\n     row_count int,\n     reserved_size varchar(50),\n     data_size varchar(50),\n     index_size varchar(50),\n     unused_size varchar(50))                              \n\nCREATE TABLE #tmpSizeInt (\n     table_name sysname ,\n     row_count int,\n     reserved_size_KB int,\n     data_size_KB int,\n     index_size_KB int,\n     unused_size_KB int)   \n\nSET NOCOUNT ON\nINSERT      #tmpSizeChar\nEXEC      sp_msforeachtable 'sp_spaceused ''?'''     \n\nINSERT INTO #tmpSizeInt (\n        table_name,\n        row_count,\n        reserved_size_KB,\n        data_size_KB,\n        index_size_KB,\n        unused_size_KB\n        )\nSELECT  [table_name],\n        row_count,\n        CAST(SUBSTRING(reserved_size, 0, PATINDEX('% %', reserved_size)) AS int)reserved_size,\n        CAST(SUBSTRING(data_size, 0, PATINDEX('% %', data_size)) AS int)data_size,\n        CAST(SUBSTRING(index_size, 0, PATINDEX('% %', index_size)) AS int)index_size,\n        CAST(SUBSTRING(unused_size, 0, PATINDEX('% %', unused_size)) AS int)unused_size\nFROM #tmpSizeChar   \n\n/*\nDROP TABLE #tmpSizeChar\nDROP TABLE #tmpSizeInt\n*/\n\nSELECT * FROM #tmpSizeInt\nORDER BY reserved_size_KB DESC\n</pre>\n"}, {'answer_id': 2721, 'author': 'brendan', 'author_id': 225, 'author_profile': 'https://Stackoverflow.com/users/225', 'pm_score': 0, 'selected': False, 'text': '<p>Check out this, I know it works in 2005 (<a href="https://learn.microsoft.com/sql/relational-databases/system-catalog-views/sys-database-files-transact-sql" rel="nofollow noreferrer">Microsoft Documentation</a>):</p>\n\n<p>Here is is for the pubs DB\n<pre><code>\nselect *\nfrom pubs.sys.database_files\n</pre></code></p>\n\n<p>Returns the size  and max_size.</p>\n'}, {'answer_id': 34794972, 'author': 'ttomsen', 'author_id': 166109, 'author_profile': 'https://Stackoverflow.com/users/166109', 'pm_score': 0, 'selected': False, 'text': '<p>sp_spaceused tableName</p>\n<p>where tableName is the name of the table you want to know.</p>\n'}]
['https://Stackoverflow.com/questions/2714', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/434/']