aaronk Well-Known Member Licensed User Longtime User Jun 8, 2015 #1 Hi, Just wonder if I was to create a SQLite database how many tables can you have in it ?
Erel B4X founder Staff member Licensed User Longtime User Jun 8, 2015 #2 There is no limit to the number of tables. Upvote 0
C charlesg Member Licensed User Longtime User Jun 8, 2015 #3 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
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.
