On Dec 2, 2009, at 4:38 AM, Nick Shaw wrote: > You don't need to define the PRIMARY KEY as NOT NULL - it's implied. > The column constraint flow diagram in the documentation in fact > doesn't > allow it: > http://www.sqlite.org/syntaxdiagrams.html#column-constraint >
That diagram is the syntax for a single constraint. You can have multiple constraints per column. (See http://www.sqlite.org/syntaxdiagrams.html#column-def) The PRIMARY KEY is one constraint and NOT NULL is another constraint. The two can occur together and in any order. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users