Get Table Size in SQL Server

In this blog we will see how to get the table size in SQL Server.

Write the following script in SQL Server.

SP_SPACEUSED 'Student'

Here Student is the name of the table in the database. Execute the query and check the output.


We get the relevant information regarding the table. So using this query we can calculate the size of a table.