Assertion: trigger's statement | /r/Causes | trigger
Facets:
value: to fire
type: PURPOSE
Source sentences:
text: The Triggering Event or Statement A triggering event or statement is the SQL statement, database event, or user event that causes a trigger to fire.
text: 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.
text: Also, triggers can contain statements that cause other triggers to fire (cascading triggers).
text: When a statement in a trigger body causes another trigger to fire, the triggers are said to be cascading.
text: A triggering event or statement is the SQL statement, database event, or user event that causes a trigger to fire.
text: However if an ON CONFLICT clause is specified as part of the statement causing the trigger to fire, then conflict handling policy of the outer statement is used instead.