Helpful Information
 
 
Category: Firebird SQL Development
Maximum number of tables per database?

" Maximum number of tables per database: 64Kb"
I need more info!

The actual limit will be imposed on your operating system and the maximum file size.

Originally posted by victorpendleton
The actual limit will be imposed on your operating system and the maximum file size.
Yes, but, can you measure a "number" in "kb" :confused: (if you know what I meen)

I would guess this means that the maximum number of tables per database is 65536. My guess is that this include the system tables (never counted them, but it is somewhere between 10 and 99). Anyway, you should examine your design if you are anywhere near this limit, I've never heard of anyone complaining that Firebird cannot create enough tables.










privacy (GDPR)