There are multiple ways of getting the table(s) size in the Microsoft SQL Server database. In this tutorial, we are going to show you the steps on getting the table(s) size using the Microsoft SQL Server Management Studio (2014).
Launch the SQL Server Management Studio and login with the authorized user.
Method 1: Command Line
Use the command line below.
sp_spaceused "SCHEMA".TABLE_NAME"
Method 2: Table Property
Right click on the Table folder to filter and search for the desire table. Once the table is found, right click on the table name and select Properties.
Now, select Storage and on the right panel, you will get the table size from the Data space row under General field. In this example, the size of table SNAP is 177.273MB,
Method 3: Object Explorer Details
Firstly, double click on database name and use keyboard shortcut F7 to open the Object Explorer Details. Search for the table name from the search field and double click on the table name from the output.
The details of the table, together with the Data Space Used (KB) will be list out as per below screenshot.
