I was trying to work out if I could add a FOREIGN KEY to a table after it is originally created, using the ALTER TABLE command. I think there's an error on
http://www.sqlite.org/syntaxdiagrams.html I cannot find anything on that page that includes the actual words 'FOREIGN KEY'. The section http://www.sqlite.org/syntaxdiagrams.html#foreign-key-clause starts with the word 'REFERENCES'. I traced up and down the hierarchy but I couldn't find 'FOREIGN KEY'. This is not consistent with the description of creating FK constraints as described in http://www.sqlite.org/foreignkeys.html Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users