Ways to Get Table Row Counts in Sql Server.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 213
SELECT sc.name +'.'+ ta.name TableName, SUM(pa.rows) Row_Count
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;

Comments or Responses

Login to post response