On Tue, Aug 26, 2003 at 18:34:04 +0100, Richard Huxton <[EMAIL PROTECTED]> wrote: > On Tuesday 26 August 2003 15:06, Andreas Fromm wrote: > > > > When I delete a record of the table realtions I also want to delete the > > record on the data-tables if there is no other record referencing them. > > How can I do this? > > You want to add "ON DELETE CASCADE" to the REFERENCES... clause. > See the SQL reference for full syntax details.
I don't think that is what he wants. He seems to want to go in the other direction. That is going to require custom triggers and probably adding a reference count column to data-tables. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
