MERGE as a Triggering Action - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

MERGE as a Triggering Action

If subquery returns no rows, then no triggers are fired.

Triggers invoke the following behavior when fired as the result of a MERGE request:

 

IF a trigger is defined on this type of action …

THEN it is fired when this clause is specified …

AND match_condition is …

UPDATE

WHEN MATCHED THEN

met.

DELETE

WHEN MATCHED THEN

met.

INSERT

WHEN NOT MATCHED THEN

not met.