* John Newby <[EMAIL PROTECTED]> [2006-08-10 00:25]: > it recognises them if you put them in your create table > statement but it does not enforce them, is this correct?
Yes. But note that you can retrofit enforcement yourself. Take a look at Enforce Foreign Key Integrity in SQLite with Triggers http://www.justatheory.com/computers/databases/sqlite/foreign_key_triggers.html Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/>