Andy Allord wrote:
I am new to SQLite 3 and I am wondering if there is a way to work with foreign keys and set handling to cascade?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
There is no direct support for foreign keys in SQLite, although the statements are parsed but produce no effects. However, you can use triggers to implement their behavior yourself. A starting point could be this trigger generator: http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to