Gary Sieling

Finding the number of rows of all tables in a SQL Server database

The following query finds all tables in a schema, ordered by row count:

SELECT
    sysobjects.*
    , sysindexes.Rows
FROM
    sysobjects
    INNER JOIN sysindexes
    ON sysobjects.id = sysindexes.id
WHERE
    type = 'U'
    AND sysindexes.IndId < 2
ORDER BY sysindexes.Rows desc
Exit mobile version