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

How to Get Rowcount of Every Table in SSMS? - Interview Question of the Week #288 getrowcount0-800x588

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.

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

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

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

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.

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

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.

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

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)

Author: admin

Leave a Reply

Your email address will not be published.