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. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
