SQL: Get total and average row count per table and/or database

get-total-average-row-counts.sql

/* SQL: Get total and average row count per table and/or database */

USE SomeDB;
GO

CREATE TABLE #counts
(
    table_name varchar(255),
    row_count int
)

EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
-- Row count per table
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
-- Total DB row count
SELECT SUM(row_count) AS total_row_count FROM #counts
-- Average DB row count
SELECT AVG(row_count) AS average_row_count FROM #counts
DROP TABLE #counts