Get Table Size in SQL Server | Query to Get Table Size in SQL Server 2008

get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to get table size in SQL server.

To get table size in SQL server we need to write the query like as shown below

Syntax

SP_SPACEUSED 'YOUR TABLE NAME'

Example

SP_SPACEUSED 'USERDETAILS'

Once we run above query we will get output like as shown below

Demo