Re: [sqlite] Test Foreign Key Column

2011-04-27 Thread M.Ozeau
o create each > table. Foreign fields will have a REFERENCES key word. > > Regards, > > ¬Jonathan > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of M.Ozeau > Sent: 26 April 2011 17:06 >

[sqlite] Test Foreign Key Column

2011-04-26 Thread M.Ozeau
Hi and sorry for my poor English. I want to know if is it possible to test if a column is a foreign key. I mean, where the "constraint" is stored ? The only system table i know for Sqlite is the "sqlite_master" but can't find anything in her for the foreign key. For example, if i have a table