Re: [sqlite] Max limits on the following
"Shailesh Birari" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks for the input but the link you sent does not cover the > following > > 1) Max number of tables in the sqlite database? > 3) Max column name size? > 4) Max table name size? > 5) Max database name size? > 6) Max constraint name size? > 7) Max table constraints in the table? There are no hard limits on these. 3 through 6 are effectively constrained by the limit on the size of a SQL statement, as they need to appear in CREATE TABLE at some point. 1 and 7 are only constrained by database size. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Max limits on the following
Thanks for the input but the link you sent does not cover the following 1) Max number of tables in the sqlite database? 3) Max column name size? 4) Max table name size? 5) Max database name size? 6) Max constraint name size? 7) Max table constraints in the table? Pardon me if I have missed out on reading these points. Thanks Shailesh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marco Bambini > Sent: Monday, June 23, 2008 1:06 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Max limits on the following > > http://www.sqlite.org/limits.html > --- > Marco Bambini > http://www.sqlabs.net > http://www.sqlabs.net/blog/ > http://www.sqlabs.net/realsqlserver/ > > > > On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote: > > > Hello all, > > I wanted to know if there are any upper limits on the following: I > > have seen sqlite_ext.h but did not any so just wanted to > confirm the > > same. > > > > 1) Max number of tables in the sqlite database? > > 2) Max number of fields/columns in the table : 2000?? > > 3) Max column name size? > > 4) Max table name size? > > 5) Max database name size? > > 6) Max constraint name size? > > 7) Max table constraints in the table:? > > > > Kindly let me know, > > Regards > > Shailesh > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Max limits on the following
http://www.sqlite.org/limits.html --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote: > Hello all, > I wanted to know if there are any upper limits on the following: I > have > seen sqlite_ext.h but did not any so just wanted to confirm the same. > > 1) Max number of tables in the sqlite database? > 2) Max number of fields/columns in the table : 2000?? > 3) Max column name size? > 4) Max table name size? > 5) Max database name size? > 6) Max constraint name size? > 7) Max table constraints in the table:? > > Kindly let me know, > Regards > Shailesh > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Max limits on the following
Hello all, I wanted to know if there are any upper limits on the following: I have seen sqlite_ext.h but did not any so just wanted to confirm the same. 1) Max number of tables in the sqlite database? 2) Max number of fields/columns in the table : 2000?? 3) Max column name size? 4) Max table name size? 5) Max database name size? 6) Max constraint name size? 7) Max table constraints in the table:? Kindly let me know, Regards Shailesh ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users