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.