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.

Follow @AbhithRajanAbhith RajanMarch 11, 2018 · 1 min read · Last Updated: March 11, 2018

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

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

sql-server

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

Written byAbhith Rajan Follow @AbhithRajan
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 👍.
Connect

Is this page helpful?

Buy me a coffee ☕

Related SnippetsView All

Create New Database Level User

Create a database-level user in SQL Server/Azure SQL.

Last Updated · January 23, 2022

UTC to UAE Time (Arabian Standard Time)

Convert UTC time to Arabian Standard Time in SQL Server

Last Updated · September 07, 2021

Related ArticlesView All

Style Guide - SQL Server Auditing Column Names

February 05, 2020 · 1 min read

Naming convention for auditing fields in a SQL server table.

by Abhith Rajan

sql-server style-guide

SQL Server - Delete Duplicate Rows

December 04, 2019 · 2 min read

Delete duplicate records from a SQL server table without primary keys or any unique columns.

by Abhith Rajan

sql-server

Dapper - Execute Multiple Stored Procedures

September 05, 2019 · 2 min read

Dapper provides extension methods to execute multiple queries within the same command. The same can be used to execute multiple stored procedures.

by Abhith Rajan

dapper sql-server orm

Create SQL Server Database From a Script in Docker-Compose

May 21, 2019 · 3 min read

Run a SQL Server container with database initialized from a script using docker-compose.

by Abhith Rajan

docker sql-server

Microsoft SQL Server Guy Trying Oracle Database

May 08, 2019 · 2 min read

This post contains my personal experiences trying Oracle Database.

by Abhith Rajan

sql-server oracle-database cookbook

Docker - SQL Error on ASP.NET Core Alpine

May 07, 2019 · 2 min read

Having trouble to connect to a remote SQL server from an ASP.NET Core app running on top of Alpine dotnet on a linux container?

by Abhith Rajan

aspnet-core docker sql-server

Related StoriesView All

New and Enhanced Features in SQL Server 2022
mssqltips.com · Oct 28, 2022

Learn about some of the new features and enhancements in SQL Server 2022 and things you should consider adopting when moving to SQL Server 2022.

sql-server

Azure SQL Database now supports powerful geo-replication features for all service tiers | Azure Blog and Updates | Microsoft Azure
azure.microsoft.com · Jul 03, 2022

azure sql-server

JSON in SQL Server: The Ultimate Guide
databasestar.com · Oct 24, 2021

JSON is a popular format for storing data. Learn how to store JSON in SQL Server and how to use related functions in this guide.

sql-server

UNION And UNION ALL SQL Operators
c-sharpcorner.com · Jul 05, 2022

The primary difference between UNION and UNION ALL is union operation eliminates the duplicated rows from the result set, but union all returns all rows after.

sql-server

SQL Server Profiler Extension for Azure Data Studio
mssqltips.com · Dec 26, 2021

Learn how to install and use the SQL Server Profiler extension for Azure Data Studio to use against on-premises and cloud databases.

sql-server ide

SQL Concatenation for comma seperated list using XML PATH() without COALESCE
kodyaz.com · Oct 24, 2021

Get column values as comma seperated list using XML PATH() instead of UDF's using COALESCE

sql-server