Fetch row count of all the tables in single query from a database

USE <DataBaseName>
GO
SELECT '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' AS fulltable_name
, SCHEMA_NAME(t.schema_id) AS schema_name
, t.name AS table_name, 
i.rows
FROM sys.tables AS t INNER JOIN
sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2 
--and SCHEMA_NAME(t.schema_id) = 'dbo'