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 Object Explorer Details.

Step 3: Over here, just right click on the menu and select your desired columns. Make sure that you check the row count column.

That’s it. You are done. It is that simple to see the row count for every single table in SQL Server Management Studio. Additionally, if you do not have access to the keyboard shortcut F7, you can also find this option under SSMS >> Menu >> View >> Object Explorer Details.

Please note that this trick is for you if you want to see all the tables with their rowcount together. However, if you just want to check the details for a single table, you can also do that in SSMS by right-clicking on the table and going to the storage tab. However, I personally do not like this method as it is too many keystrokes and also mouse movement.

While you are on this topic, you can watch my latest video which is actually showing you how you can retrieve row count for the table with the scripts. I personally do not like method to use the SELECT COUNT(*) to retrieve the data from the tables as that can be very expensive.

Reference: Pinal Dave (https://blog.sqlauthority.com)