On Fri, Dec 30, 2011 at 04:10:55PM +0530, Durga D scratched on the wall: > 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). > > I need 70 columns with unique and not null. How to enable it?
Do you mean 70 columns that each have a single-column unique constraint, or a single unique constraint that crosses 70 columns? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users