Thx a lot Jonathan, Pragma seems to be just the thing i was looking for !
Regards, MoZo 2011/4/26 Jonathan Allin <[email protected]> > 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: [email protected] > [mailto:[email protected]] On Behalf Of M.Ozeau > Sent: 26 April 2011 17:06 > To: [email protected] > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Cordialement Morgan Ozeau _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
