Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
2  
SQL CE docs don't tell you. I'd suggest it's enough for your needs anyway... –  gbn Jan 9 '12 at 11:14
add comment

2 Answers

up vote 4 down vote accepted

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.

share|improve this answer
add comment

For SQLCe4, I got the response:

There is no limit on number of tables, but we do have a limit of 4GB file size.

//Daniel

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.