Using Instead of Triggers:

Triggers can be written only for tables. But the alternate of Trigger is intended to be written for views. Another of Option in the Create Trigger statement is another way of modifying views which cannot be modified through the Insert, Update or Delete statements. Recall the Join View. In case of Join View, updating or inserting can be done only on the key preserved table. That trigger is known as Instead of Trigger since unlike other triggers, the trigger body is executed instead of executing the triggering statement. A trigger performs the operations straightly on the underlying tables. They are activated for every row.