Trigger inserting updating deleting

There is also a new SQL syntax added to the CREATE TRIGGER statement to enable multiple events to be defined for the trigger.That syntax allows for the specification of the events that can be handled by the trigger.Triggers in different schemas can have the same name.

trigger inserting updating deleting-57

That information, along with your comments, will be governed by DISQUS’ privacy policy.The CREATE TRIGGER statement is used to add triggers to the database schema.Triggers are database operations that are automatically performed when a specified database event occurs.Hence explicitly specifying FOR EACH ROW is optional.FOR EACH ROW implies that the SQL statements specified in the trigger may be executed (depending on the WHEN clause) for each database row being inserted, updated or deleted by the statement causing the trigger to fire.