Fetch Row Count for All Tables in a SQL SERVER

Using a short query we can list all the tables in the database along with the number of records in each table.

Abhith Rajan
Abhith RajanMarch 11, 2018 · 1 min read · Last Updated:

Just execute the below query in the database to see the list of tables and number of records in each table.

1SELECT t.name, s.row_count
2FROM sys.tables t
3 JOIN sys.dm_db_partition_stats s
4ON t.object_id = s.object_id
5 AND t.type_desc = 'USER_TABLE'
6 AND s.index_id IN (0,1)

This page is open source. Noticed a typo? Or something unclear?
Improve this page on GitHub

Abhith Rajan

Written byAbhith Rajan
Abhith Rajan is a software engineer by day and a full-stack developer by night. He's coding for almost a decade now. He codes 🧑‍💻, write ✍️, learn 📖 and advocate 👍.

Is this page helpful?

Related SnippetsView All

Related ArticlesView All

Related VideosView All

Using SQL Data Sync for Bidirectional Data Replication in SQL Server & Azure SQL DBs | Data Exposed

Build fast, scalable data system on Azure SQL Database Hyperscale | Clearent

SQL Server 2017 Graph Database

Related Tools & ServicesView All


sequel fumpt

sqlfmt is an online SQL formatter. It is pronounced sequel fumpt. Its purpose is to beautifully format SQL statements.

SmarterASP.net - Unlimited ASP.NET Web Hosting

ASP.NET Hosting by SmarterASP.net. Unlimited ASP.NET Hosting Plans Starting at $2.95 a month.