On Fri, Dec 30, 2011 at 5:40 AM, Durga D <durga.d...@gmail.com> wrote:
> Hi all, > > I have sqlite table with 71 columns. not null for 70 and one is > surrogate key(primary key). Sqlite3 3.7.9 doesn't support not null for 70 > columns and unique(70 columns). It's worked fine upto 30 columns not null > and unique(70 columns). > What makes you think SQLite 3.7.9 doesn't support more than 70 NOT NULL or UNIQUE columns? I just tried it with 100 NOT NULL and UNIQUE columns and it works fine for me. > > I need 70 columns with unique and not null. How to enable it? > > Thanks in advance, > Durga. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users