Get the database record count on every table of database

USE  dbname--CHANGE THE DATABASE NAME only HERE, I am using dbnamefor example, rest code will as it  is

GO

SELECT      SCHEMA_NAME(SystemObject.schema_id) + '.' +

        SystemObject.Name AS 'Table Name', SUM(SystemPartition.rows) AS 'No of Record'

FROM        sys.objects SystemObject

INNER JOIN sys.partitions SystemPartition ON SystemObject.object_id = SystemPartition.object_id

WHERE       SystemObject.type = 'U'

GROUP BY    SystemObject.schema_id, SystemObject.Name

GO