On Mon, 20 Jul 2009, Kees Nuyt wrote: > After a dynamic development phase, most databases have a static schema. > At-run-time schema changes are usually a result of bad design. Run-time > schema changes on referential constraints are very unlikely.
Kees, You said it much better than did I. > drh told us implementing real referential constraints in SQLite is > difficult. I think we'll have to do with triggers for quite some time, > which IMHO is no problem for a Lite product. And, if you have working triggers in your existing schema, there's no reason to change them by running .genfkey. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users