The columns in the grid are:
Table Name
The name of the table.
Database Name
The name of the database that contains the specified table.
Partition
The partition where the table is stored.
Data Space
The data space (filegroup, partition scheme, or FILESTREAM data filegroup) where the table is stored.
Owner
The name of the table owner.
Rows
The number of rows in the table.
Reserved MB
The amount of space reserved for the table in megabytes.
Free MB
The amount of free space in the table.
Pct DB
The percentage of space that the table occupies in the database.
Table MB
The actual size of the table in megabytes.
Used MB
The amount of used space in the table.
The Tables grid and the Databases grid
The number of tables shown in the Tables grid may not match the number displayed in the # Tables column of the Databases grid. This is most evident when viewing table details for the tempdb database and is due to its dynamic nature.
How to highlight the records you are interested in
You can restrict the tables included in the charts below by highlighting just the records you are interested in. Hold down the Shift key to select a block of multiple records, or the CTRL key to select individual records.
How to filter the results
You can filter the results displayed in the Tables grid by the following criteria:
- Top N tables by size or row count
- Data Space name
- Table name
To filter the results, type appropriate values into the fields above the Tables grid and then click Apply Filter.