According to http://www.sqlite.org/lang_createtable.html you can mention foreign-key-clause (starting with REFERENCES) as column-constraint. Why it doesn't work for you?
Pavel On Wed, Nov 25, 2009 at 10:33 AM, Jan <janus...@gmx.net> wrote: > Hi, > > I am testing the new fk support in my db. Currently I have *column > constraints* for fk that were parsed by genfkey to create triggers. > > Simply adding FOREIGN KEY (column) to the column constr. seems not to > work. But moving everything to the end of the table definition as a > table constraint works. > > As far as I understand the docu is correct here (it is not possible tu > use FOREIGN KEY in column constr.). But CHECK constraints are. Why is > there a difference? > > Jan > > > _______________________________________________ > 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