B4J Question SQLite Table Limit

Discussion in 'B4J Questions' started by aaronk, Jun 8, 2015.

Similar threads

B4J Tutorial TableView Tutorial
B4A Tutorial [B4X] Smart String Literal
B4J Library [B4X] DBUtils 2
B4J Tutorial [WebApp] Concurrent access to SQLite databases
B4J Tutorial SQL Tutorial
  1. aaronk

    aaronk Well-Known Member Licensed User


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

    Erel Administrator Staff Member Licensed User

    There is no limit to the number of tables.
  3. charlesg

    charlesg Member Licensed 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.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice