Implement/use foreign keys in SQLite?
How can I implement a foreign key in SQLite? I was thinking something like this:
CREATE TABLE job (_id INTEGER PRIMARY KEY AUTOINCREMENT, employer_id INTEGER, ...); CREATE TABLE employer(_id INTEGER, employer_name TEXT NOT NULL, ...);
Where employer_id is the _id from the table employer. Would this work? Is there another fast, maybe less prone to error way? Maybe with triggers?
Maybe I don't understand the question, but if it's the constraint you want, just do this:
ALTER TABLE Job ADD FOREIGN KEY (employer_id) REFERENCES Employer(_id) ON DELETE NO ACTION ON UPDATE NO ACTION;
(Earlier version of SQLite do not support enforced FK relationships.)