Max number of tables in an Sql server database

Question

I have been researching how many different tables and schemas I can put into a single sql server database, but I keep running into the following phrase:

Limited by number of objects in a database

But when I research the max number of objects in a database, I am unable to find a clear definition of this limitation.

Any ideas?

my question is more about the "potential" not the current count. I.E. If I filled a databases sys.objects table, what would "select count(*) from sys.objects" return? — Nathan Tregillus, Oct 02 '14 at 16:11
sounds like you are just asking this: http://stackoverflow.com/questions/8786392/max-number-of-tables-objects-in-sql-server-editions-compact-express — KHeaney, Oct 02 '14 at 16:13
ha! thanks, I think I was just not asking the correct question. thank you @KHeaney! — Nathan Tregillus, Oct 02 '14 at 16:18
WAY more than you should ever have. If you are truly concerned that you might be running out of objects you need to redesign nearly everything. — Sean Lange, Oct 02 '14 at 16:57

score 6 · Accepted Answer · answered Oct 02 '14 at 16:19

A fine note at the bottom of this page:

3 - 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.

So 2^31 - 1 it is.

Max number of tables in an Sql server database

1 Answers1