How to get the Rowcount for all Tables in a Database

USE DatabaseName

SELECT sc.name +'.'+ tbl.name TableName
,SUM(pat.rows) RowCountvalue
FROM sys.tables tbl
INNER JOIN sys.partitions pat ON pat.OBJECT_ID = tbl.OBJECT_ID
INNER JOIN sys.schemas sc ON tbl.schema_id = sc.schema_id
WHERE tbl.is_ms_shipped = 0 AND pat.index_id IN (1,0)
AND sc.name = 'dbo'
GROUP BY sc.name,tbl.name
ORDER BY SUM(pat.rows) DESC

output