Triggers are special kind of stored
procedures that get executed automatically when an INSERT, UPDATE or DELETE
operation takes place on a table.
After Triggers that
run after an update, insert, or delete can be used in
several ways.
An
AFTER trigger can be
created only on tables, not on views.
Instead Of Triggers fire instead of the operation that fires
the trigger, so if you define an Instead Of trigger on a table for the Delete operation, they try to delete rows,
they will not actually get deleted. INSTEAD OF triggers
can be specified on both tables and views.
No comments:
Post a Comment