How to get the Row Count of each table in a Database in SQL Server?
If you are working with SQL Server and looking for a way to get the row count of all tables in your database, you can do that using this SQL Query.
This Query will display a list of all Tables in your database and a count of the number of Rows the table has.
SELECT object_name(id) AS TableName, rowcnt as Rows FROM sys.sysindexes
WHERE object_name(id) not like 'sys%' and indid = 1
ORDER BY TableName