Thx a lot Jonathan, Pragma seems to be just the thing i was looking for !
Regards, MoZo 2011/4/26 Jonathan Allin <jonat...@jonathanallin.com> > I had to use the pragmas: > # foreign_key_list > # foreign_keys > > But also the sqlite_master table includes the command used to 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 > 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 for Sqlite is the "sqlite_master" but can't > find anything in her for the foreign key. > > For example, if i have a table "Person", and a Table "Country" , i can have > a integer column 'Country_ID' as foreign key in my table "Person". > > Is there any method to test, (i mean in sql language) if the integer column > 'Country_ID' is used as a foreign key or if it's just an integer column > > -- > Cordialy MoZo > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cordialement Morgan Ozeau _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users