Search code examples
sql-serversql-server-ce-4sql-server-2008r2-express

Max number of tables (objects) in SQL Server editions (compact, express)

What are the maximum number of tables that you can have in:

  • SQL CE4
  • SQL 2008 R2 Express

Numbers here http://msdn.microsoft.com/en-us/library/ms143432.aspx I guess is for SQL Server 2008, but are they valid for Express and what about SQL CE4?

The sum of the number of all objects in a database cannot exceed 2,147,483,647

BTW. Sorry for duplicating questions, but it seems to me Stackoverflow is providing answers more quickly.

Solution

  • No word about CE, but Express is normal SQL Server + database size and memory / processr limitations.... If you can fit yoru tables into the size, the normal SQL Server limity apply.