Ömer Faruk Kurt (Java Developer)

How to fetch the row count for all tables in a SQL SERVER database

Hello, For SQL Server, it will be enough to run the following script to get the record counts in all tables.

SELECT t.name AS table_name ,s.row_count AS row_count FROM sys.tables t JOIN sys.dm_db_partition_stats s ON t.OBJECT_ID = s…