Durga D <durga.d...@gmail.com> wrote: > I tested with below query to create a table: > > "create table if not exists durtree (id integer primary key autoincrement, > c1 varchar[260], c2 varchar[260], c3 varchar[260], c4 varchar[260], c5 > varchar[260], c6 varchar[260], c7 varchar[260], c8 varchar[260], c9 > varchar[260], c10 varchar[260], c11 varchar[260], c12 varchar[260], c13 > varchar[260], c14 varchar[260], c15 varchar[260], c16 varchar[260], c17 > varchar[260], c18 varchar[260], c19 varchar[260], c20 varchar[260], c21 > varchar[260], c22 varchar[260], c23 varchar[260], c24 varchar[260], c25 > varchar[260], c26 varchar[260], c27 varchar[260], c28 varchar[260], c29 > varchar[260], c30 varchar[260], c31 varchar[260], c32 varchar[260], c33 > varchar[260], c34 varchar[260], c35 varchar[260], c36 varchar[260], c37 > varchar[260], c38 varchar[260], c39 varchar[260], c40 varchar[260], c41 > varchar[260], c42 varchar[260] default null, c43 varchar[260] default null, > c44 varchar[260] default null, c45 varchar[260] default null, c46 > varchar[260] default null, c47 varchar[260] default null, c48 varchar[260] > default null, c49 varchar[260] default null, c50 varchar[260] default null, > c51 varchar[260] default null, c52 varchar[260] defaul null, c53 > varchar[260] default null, c54 varchar[260] defaul null, c55 varchar[260] > default null, c56 varchar[260] default null, c57 varchar[260] default null, > c58 varchar[260] default null, c59 varchar[260] default null, c60 > varchar[260] default null, c61 varchar[260] default null, c62 varchar[260] > default null, c63 varchar[260] default null, c64 varchar[260] default null, > c65 varchar[260] default null, c66 varchar[260] default null, c67 > varchar[260] default null, c68 varchar[260] default null, c69 varchar[260] > default null, c70 varchar[260] default null, unique (c1, c2, c3, c4, c5, > c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, > c22, c23, c24, c25, c26, c27, c28, c29, c30, c31, c32, c33, c34, c35, c36, > c37, c38, c39, c40, c41, c42, c43, c44, c45, c46, c47, c48, c49, c50, c51, > c52, c53, c54, c55, c56, c57, c58, c59, c60, c61, c62, c63, c64, c65, c66, > c67, c68, c69, c70));"
This query works for me as written. I also added about a dozen more "default null" clauses, and it still worked (though, as Simon noted, "default null" is redundant). What specifically seems to be the problem? You say, variously, that you "could not" do X, or SQLite "doesn't support" Y. What makes you believe that? What is it you do, exactly, what results do you observe, and how do these results differ from your expectations? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
