O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A trigger is a special type of database code that is associated with a particular database table; the trigger code is executed when the table is updated. A trigger is associated with one or more update operations (Insert, Update, or Delete). Multiple triggers can be associated with the same update operation, but it can be difficult to control the order in which triggers are fired.[66]

Triggers have a variety of uses:

·         Validation: Triggers can do complex data validation checking at update time, and fail updates for which the validation is unsuccessful. They are especially useful for cross-database validation (checking data against data in other databases), since standard database constraints won’t work across database boundaries. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required