I want to make simple trigger. I have table 'genre' and 'artist', 'artist' have foreign key 'genre_id' which is the primary key in 'genre' table I want the trigger to delete artist wchich have the same foreign key as the deleted genre for example: "delete from artist where genre_id = '10'" is triggered when "delete from genre where genre_id = '10'" is call.
here is the form to fill : CREATE TRIGGER delete_artist BEFORE DELETE ON genre BEGIN /* Insert trigger body here */ END; -- View this message in context: http://www.nabble.com/Trigger-%28on-delete%29-tp18632270p18632270.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