title: Get row count of all tables in database: SQL Server
body: <p>I'm trying to familiarize myself with a large database and search for relevant information among the many tables. I often find myself calling up a table, to see if there is relevant data inside, only to find that the table has no records.</p>
  
  <p>How to quickly call up a list of all tables and the number of records contained therein? I'm using sql server 2008.</p>
  
  <p>Thanks!</p>
  
  <p>Related Question: <a href="https://stackoverflow.com/questions/17066013/how-do-i-quickly-check-many-sql-database-tables-and-views-to-see-if-they-are-not">How do I QUICKLY check many sql database tables and views to see if they are not empty or contain records</a></p>