TRIGGER 문

<get trigger statement>

GET TRIGGER TRACE [ { TO | INTO }
<variable> ]
| GET TRIGGER [ MAXIMUM ] DEPTH [ { TO | INTO } <variable> ]

<set trigger statement>

SET TRIGGER TRACE <trace spec>
| SET TRIGGER [ MAXIMUM ] DEPTH <depth spec>

<trace spec>

{ ON | OFF }
| <unsigned integer literal>
| <variable>

<depth spec>

INFINITE
| <unsigned integer literal>
| <variable>

예제

CREATE TRIGGER check_age_update
BEFORE UPDATE ON person(age)
IF new.age < obj.age
EXECUTE REJECT;

CREATE TRIGGER emit_message_on_commit
BEFORE COMMIT
EXECUTE PRINT "Committing transaction.";

ALTER TRIGGER check_age_update PRIORITY 10.0;

ALTER TRIGGER emit_message_on_commit STATUS INACTIVE;