Re: [sqlite] Error in documentation for FOREIGN KEY ?

2010-03-14 Thread Simon Slavin
On 14 Mar 2010, at 11:13pm, Kees Nuyt wrote: > Well, it is consistent, when you take > http://www.sqlite.org/syntaxdiagrams.html#table-constraint > into account. > > CREATE TABLE is the only statement where references > constraints can be defined. Have a look at > http://www.sqlite.org/lang_cre

Re: [sqlite] Error in documentation for FOREIGN KEY ?

2010-03-14 Thread Kees Nuyt
On Sun, 14 Mar 2010 22:04:18 +, Simon Slavin wrote: > 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 tha

Re: [sqlite] Error in documentation for FOREIGN KEY ?

2010-03-14 Thread Jay A. Kreibich
On Sun, Mar 14, 2010 at 10:04:18PM +, Simon Slavin scratched on the wall: > http://www.sqlite.org/syntaxdiagrams.html > > I cannot find anything on that page that includes the actual > words 'FOREIGN KEY'. http://www.sqlite.org/syntaxdiagrams.html#table-constraint For a column constrai

[sqlite] Error in documentation for FOREIGN KEY ?

2010-03-14 Thread Simon Slavin
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