GET TRIGGER TRACE [ { TO | INTO }
<variable> ]
| GET TRIGGER [ MAXIMUM ] DEPTH [ { TO | INTO } <variable> ]
SET TRIGGER TRACE <trace spec>
| SET TRIGGER [ MAXIMUM ] DEPTH <depth spec>
{ ON | OFF }
| <unsigned integer literal>
| <variable>
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;