Get Table Row Count

/****** Script for SelectTopNRows command from SSMS  ******/

      use adeffx_data_master
  SELECT SCHEMA_NAME(schema_id) AS [SchemaName],
[Tables].name AS [TableName],
SUM([Partitions].[rows]) AS [TotalRowCount]
FROM sys.tables AS [Tables]
JOIN sys.partitions AS [Partitions]
ON [Tables].[object_id] = [Partitions].[object_id]
AND [Partitions].index_id IN ( 0, 1 )
WHERE [Tables].name = N'mid_group_id_map'
GROUP BY SCHEMA_NAME(schema_id), [Tables].name;