How to find table row count?

--Use below query to find table row count
select so.name,sp.rows from sys.objects so inner join sys.partitions sp
on so.object_id = sp.object_id
where so.type in ('TF','U','V')
and sp.index_id <= 1
order by so.name