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.
read more