Blog Post

Sql Server – Listing all tables Metadata (Table Size, row count, Index Size)

,

Sql Server – Listing all

tables Metadata (Table Size, row count, Index Size)

Suppose you need to find out Table size, row

count , index size etc. for a table. In this case the easiest way to do that is

using sp_spaceused, here is the syntax –

EXEC sp_spaceused 'TableName' Like EXEC sp_spaceused 'DimCustomer'

The output will be something like that –

name

rows

reserved

Rate

Share

Share

Rate