B4J Question SQLite Table Limit

aaronk

Well-Known Member
Licensed User
Longtime User
Hi,

Just wonder if I was to create a SQLite database how many tables can you have in it ?
 

charlesg

Member
Licensed User
Longtime User
Don't worry about it!

"Each table and index requires at least one page in the database file. An "index" in the previous sentence means an index created explicitly using a CREATE INDEXstatement or implicit indices created by UNIQUE and PRIMARY KEY constraints. Since the maximum number of pages in a database file is 2147483646 (a little over 2 billion) this is also then an upper bound on the number of tables and indices in a schema." SQLite documentation.
 
Upvote 0
Top