On Wed, Aug 11, 2004 at 05:09:49PM -0700, Cliff Hudson wrote:
> engine in a mobile device. Foreign key constraints are one of the features
> I would like to see in any database engine we eventually use. According to
> the web site, this feature is not yet implemented, and the mailing list
This doesn't answer your question, but you can use triggers to implement
things like "on delete cascade", e.g.
CREATE TRIGGER recording_disc_id_delete DELETE ON disc
BEGIN
DELETE FROM recording WHERE disc_id=old.id;
END;
If you have a lot of tables, you could use a scripting language to generate
the triggers based on sqlite metadata. For some metadata PRAGMAs see:
http://sqlite.org/lang.html#pragma
Dave Cook
