How to Get Rowcount of Every Table in SSMS? – Interview Question of the Week #288


 

Question: How to Get Rowcount of Every Table in SSMS?

Answer: After watching my earlier video on the fastest way to get the rowcount for the table, I got lots of questions from the user, if there is a way to list rowcount for every single table in SQL Server Management Studio. Honestly, there is a very simple way to do this in SSMS. Let us see how you can do that.

Step 1: Navigate to your database and tables folder of which you want to list tables with the rowcount.

Step 2: Just type in F7 (which is SSMS shortcut) to open