How to show table row count and space used in SQL Server with SSMS

Adam Adamowicz - Dataedo Team Adam Adamowicz 2018-10-04

Table of Contents:


    There's a quick and convenient way to see row count, data and index space used in of all tables in one list with SSMS.

    First, go to View and Object Explorer Details or press F7 key to enable Object Explorer Details pane.

    Now select Tables item under the database you want to analyze in Object Explorer. List of all tables will show in Object Explorer Details pane on the right. Right click grid header and select:

    • Data Space Used (KB)
    • Index Space Used (KB)
    • Row Count

    This will add new columns with those details to the list of your tables.

    You can copy this data for further analysis and reporting.

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept