Get 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.