cancel
Showing results for 
Search instead for 
Did you mean: 

How to get a rowcount for each table in a database?

Anon
Community Manager

How to get a rowcount for each table in a database?

USE [BigDataInsightUC]

SELECT sc.name +'.'+ ta.name PrognosisTable
,SUM(pa.rows) RowCnt
FROM sys.tables ta
INNER JOIN sys.partitions pa
ON pa.OBJECT_ID = ta.OBJECT_ID
INNER JOIN sys.schemas sc
ON ta.schema_id = sc.schema_id
WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
GROUP BY sc.name,ta.name
ORDER BY SUM(pa.rows) DESC
Tags (1)