Hi William, "Duquette, William H (318K)" <william.h.duque...@jpl.nasa.gov> writes:
> What if you defined the foreign key with "ON DELETE CASCADE"? Dropping > the employer table will delete the employees. That would be bad for the normal use. In other words, I don't want the CASCADE semantics for those references and I don't think there is a way to globally turn this on for all the foreign keys. Boris -- Boris Kolpackov, Code Synthesis http://codesynthesis.com/~boris/blog Compiler-based ORM system for C++ http://codesynthesis.com/products/odb Open-source XML data binding for C++ http://codesynthesis.com/products/xsd XML data binding for embedded systems http://codesynthesis.com/products/xsde _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users