mercredi 6 juillet 2016

Update Trigger on multiple tables

I have my table design as below

Quote --> Quote_Contact -->Quote_Contact_Detail -->Breakdown

A quote has multiple quote_contact, a quote_contact has multiple quote_contact_detail and a quote_contact_detail has one breakdown.

What i want to do is when either any data changes from one of the 4 tables, i want to make a copy of the row from quote with its concerned table rows from quote_contact and so on.

I've read somewhere that triggers can sort of do this, but examples that i have been seeing contain on update from one table. So my question is, Is there any way i can do a trigger on these 4 tables at once, or any other way i could do this preferably at database level.

Aucun commentaire:

Enregistrer un commentaire