Just execute the below query in the database to see the list of tables and number of records in each table.

SELECT t.name, s.row_count 
FROM sys.tables t
	JOIN sys.dm_db_partition_stats s
ON t.object_id = s.object_id
	AND t.type_desc = 'USER_TABLE'
	AND s.index_id IN (0,1)

comments powered by Disqus

About the author

  • Abhith Rajan

    Abhith Rajan

    Abhith Rajan is a full-stack developer, consultant, Sysberries employee, and biker. Who passionate about C# and JavaScript. Works on his blog, his personal finance web app and its react native mobile app in his free time.

    Buy me a coffeeBuy me a coffee