Breaking News: Grepper is joining You.com. Read the official announcement!

tsql get size of tables

Wandering Walrus answered on February 22, 2023 Popularity 5/10 Helpfulness 6/10

answer tsql get size of tables

tsql get size of tables

Comment

DECLARE @tmpTableSizes TABLE
(
    tableName    VARCHAR(100),
    numberofRows VARCHAR(100),
    reservedSize VARCHAR(50),
    dataSize     VARCHAR(50),
    indexSize    VARCHAR(50),
    unusedSize   VARCHAR(50)
)

INSERT @tmpTableSizes 
    EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

SELECT
    tableName,
    CAST(numberofRows AS INT)                              'numberOfRows KB',
    CAST(LEFT(reservedSize, LEN(reservedSize) - 3) AS INT) 'reservedSize KB',
    CAST(LEFT(dataSize, LEN(dataSize) - 3) AS INT)         'dataSize KB',
    CAST(LEFT(indexSize, LEN(indexSize) - 3) AS INT)       'indexSize KB',
    CAST(LEFT(unusedSize, LEN(unusedSize) - 3) AS INT)     'unusedSize KB'
    FROM
        @tmpTableSizes
    ORDER BY
        [reservedSize KB] DESC

Popularity 5/10 Helpfulness 6/10 Language sql

Source: stackoverflow.com

Tags: get size sql tsql

Link to this answer
Share Copy Link

Contributed on Feb 22 2023

Wandering Walrus

0 Answers Avg Quality 2/10

tsql get size of tables

Contents

More Related Answers

tsql get size of tables

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.