Thursday 5 December 2013

What is Instead of Triggers?

Views are commonly used to separate the logical database schema from the physical schema. Unfortunately the desired transparency often falls short in the case of UPDATE, DELETE or INSERT operations, since all but the simplest views are not updatable.

Instead Of Trigger execute the trigger body instead of the triggering statement. This is used for views that are not otherwise modifiable.

Instead of Trigger can’t be written at Statement Level.

No comments:

Post a Comment