sp_spaceused 'MyTable' Returns information about the size of MyTable
Syntax:
Exec sp_spaceused 'TableName'
Query:
Exec sp_spaceused 'MyOrdersPrimary'
Output:
name rows reserved data index_size unused
----------------------------------------------------------------------------------------------------
MyOrdersPrimary 2 16 KB 8 KB 8 KB 0 KB