hey i hve created a table CREATE TABLE video_tab (video_id INTEGER, project_id INTEGER, video_path VARCHAR(100), video_length INTEGER, video_type VARCHAR(10), video_size VARCHAR(10), CONSTRAINT video_pk PRIMARY KEY(video_id, project_id), CONSTRAINT fk_project_id FOREIGN KEY (project_id) REFERENCES project_tab(project_id));
and wrote a trigger for the foreign key constraint... anyways i have to write a trigger for the foreign key constraint does CONSTRAINT fk_project_id FOREIGN KEY (project_id) REFERENCES project_tab(project_id) make any difference in the CREATE TABLE command? -- View this message in context: http://www.nabble.com/foreign-key-problems-tp23886053p23886053.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users