title: Max number of tables (objects) in SQL Server editions (compact, express)
body: <p>What are the maximum number of tables that you can have in:</p>
  
  <ul>
  <li>SQL CE4</li>
  <li>SQL 2008 R2 Express</li>
  </ul>
  
  <p>Numbers here <a href="http://msdn.microsoft.com/en-us/library/ms143432.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms143432.aspx</a> I guess is for SQL Server 2008, but are they valid for Express and what about SQL CE4?</p>
  
  <blockquote>
    <p>The sum of the number of all objects in a database cannot exceed 2,147,483,647</p>
  </blockquote>
  
  <p>BTW. Sorry for <a href="https://dba.stackexchange.com/questions/10384/max-number-of-tables-objects-in-sql-server-editions-compact-express">duplicating questions</a>, but it seems to me Stackoverflow is providing answers more quickly.</p>