The Trouble With Database Triggers by Thomas LaRock

Author:Thomas LaRock
Language: eng
Format: azw3, epub
Published: 2017-06-30T07:00:00+00:00

Cascading Changes

You can also use triggers to enforce cascading changes that aren’t necessarily tied to referential integrity (i.e., primary and foreign key definitions). For example, you might need to delete data in several tables with the push of one button. You could build a trigger on one table that would cascade your deletes.

The same is true for updates and inserts. You could cascade your changes however you see fit. Perhaps every time a row in one table is deleted, you want to update data in another. You could configure a trigger to cascade those actions along.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.