Just execute the below query in the database to see the list of tables and number of records in each table.
1SELECT t.name, s.row_count2FROM sys.tables t3 JOIN sys.dm_db_partition_stats s4ON t.object_id = s.object_id5 AND t.type_desc = 'USER_TABLE'6 AND s.index_id IN (0,1)