subject:"\[sqlite\] Test Foreign Key Column"

Re: [sqlite] Test Foreign Key Column

2011-04-27 Thread M.Ozeau

; To: sqlite-users@sqlite.org > Subject: [sqlite] Test Foreign Key Column > > 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 f

Re: [sqlite] Test Foreign Key Column

2011-04-26 Thread Jonathan Allin

-boun...@sqlite.org] On Behalf Of M.Ozeau Sent: 26 April 2011 17:06 To: sqlite-users@sqlite.org Subject: [sqlite] Test Foreign Key Column 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

[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