Re: [sqlite] How many tables can a database hold?

J. R. Westmoreland writes: > > Can someone tell me how many tables a given database can hold. > > I'm looking at an initial design of an application that could have a table > of data for each city in a state. This could be possibly more than a > thousand tables. > > With that many

Re: [sqlite] How many tables can a database hold?

> Can someone tell me how many tables a given database can hold. Try here: http://www.sqlite.org/limits.html > I'm looking at an initial design of an application that could have a table > of data for each city in a state. This could be possibly more than a > thousand tables. Is the data stored

Re: [sqlite] How many tables can a database hold?

J.R, --I'd suggest you check out URL: http://www.sqlite.org/limits.html --joins are typically limited to 64 tables --Assuming you (CAN) define a database with >1000 tables, IMHO, this is a fairly unconventional design strategy, if rarely needed -- some would say this is inadvisable. Typically