tables limit in database?

bungpeng

bungpeng

Well-known member
Joined
Sep 10, 2002
Messages
906
Location
Malaysia
Does anyone know what is the tables limit in database?
No matter it is SQL Server, Oracle, MySQL, Access...

Or any recommendation for number of tables allow in database? because too many might affect the stability of the database?
 
Access can have a total of 32,768 objects in the database. I must admit I didnt believe this so I wrote a simple little script to test it and now have an Access database with 32,000 tables in it. Its around 267Mb and theyre all empty. In SQL Server, tables are limited by the number of objects in the DB too, which is 2,147,483,647^4. Not sure about Oracle but assume its at least this much.

For more info:
Access Help -> "Access Specifications"
SQL BOL -> "maximum capacity specifications"
 
It might support many tables, but what I worry is that: too many tables will it affect the stability of the database?
 
Back
Top