Sqlite parser DOES parse foreign key constraints. Try this: create table t1( id integer, id1 integer, id2 integer, id3 integer, foreign key (id1,id2) references anotherTable(id,id1), foreign key (id3) references somethingElse(id) );
pragma foreign_key_list(t1); However, this does not mean that it actually DOES anything with this info, it is just there for you to act, not for the engine (yet) > -----Original Message----- > From: Dick Davies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 3:52 PM > To: SQLite > Subject: [sqlite] foreign keys? (sqlite3) > > > The docs seem to say sqlite3 does'nt support foreign keys, is > that correct? > > If so, I don't understand what > > -------------------------------8<----------------------------- > --------------- > # > PRAGMA foreign_key_list(table-name); > > For each foreign key that references a column in the argument > table, invoke the callback function with information about > that foreign key. > The callback function will be invoked once for each column in > each foreign key. > -------------------------------8<----------------------------- > --------------- > > actually does? > > -- > 'The pie is ready. You guys like swarms of things, right?' > -- Bender > Rasputin :: Jack of All Trades - Master of Nuns > > >
