patternsqlMinor
Max number of tables (objects) in SQL Server editions (compact, express)
Viewed 0 times
tablesnumbereditionsexpressobjectssqlmaxservercompact
Problem
What are the maximum number of tables that you can have in:
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
- 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
Solution
The capacity specifications are valid for Express apart from the limitations listed in:
So yes, the maximum number of tables is limited by the 2,147,483,647 object maximum in Express.
Compact Edition differs substantially from Express, with very different capacity specifications. Haven't found an explicit reference to the maximum table or object count in CE but the 4GB size limit would prevent you getting anywhere near 2,147,483,647.
- Features Supported by the Editions of SQL Server 2008 R2
- Maximum Number of Processors Supported by the Editions of SQL Server (max 1 cpu)
- Memory Supported by the Editions of SQL Server (max 1GB ram)
So yes, the maximum number of tables is limited by the 2,147,483,647 object maximum in Express.
Compact Edition differs substantially from Express, with very different capacity specifications. Haven't found an explicit reference to the maximum table or object count in CE but the 4GB size limit would prevent you getting anywhere near 2,147,483,647.
Context
StackExchange Database Administrators Q#10384, answer score: 4
Revisions (0)
No revisions yet.