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