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