CODEWITHSUNDEEP
sqlsql-serverazureazure-sql-database
Eric Yin
Eric Yin

Reputation: 8973

How many tables can I have in 1 Sql Azure Database

I know in Sql Server, Tables per database "Limited by number of objects in a database", "Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647."

My question is, whats the max number for the tables I can create in one Sql Azure Databse?

Thanks

Upvotes: 1

Views: 2649

Answers (2)

astaykov
astaykov

Reputation: 30903

Remus is right!

And if you are on a study, better look for size limits, because the current maximum size of an SQL Azure database is 50 GB. Which means that if your database is larger than that, you'll have to wait for new bigger limits to become available. And this is defenitely something that is not changeble via a support ticket.

Other than that you can quickly check your database for SQL Azure compatability using the SQL Azure Migration Wizard from CodePlex - an easy to use SQL Server <-> SQL Azure migration tool.

Upvotes: 2

Remus Rusanu
Remus Rusanu

Reputation: 294217

If you find yourself asking this question, then your plan is flawed. No sane design will need 2 billion objects in a database, or anything close to that.

The official Guidelines and Limitation document mentions some of the limits supported (eg. 150 databases per server). The limit you are asking for is not documented.

Upvotes: 2

Related Questions