Loading ...

Find number of rows in each table in SQL | CodeAsp.Net

Find number of rows in each table in SQL

0 (0votes)


One of the person was asking on forums about how to find the number of rows in each table in SQL. So I am writing this blog and showing the script will give you a list of tables with count of rows. Here is the script :


([TableName] VARCHAR(255),[NumberOfRows] BIGINT)


EXEC sp_MSForEachtable 'SELECT ''?'',COUNT(*) FROM ?'

SELECT * FROM @temp ORDER BY TableName


What I have done above is just created a temp table and I run the sp_MSforeachtable stored procedure with the paramater'SELECT ''?'',COUNT(*) FROM ?''. sp_MSforeachtable  will loop through all the tables in the database. Below is the screenshot of the output which I was getting when I run the same query in AdventureWorks DB.





Do let me know your feedback, comments.




Comments (no comments yet)

Top Posts