Apache Derby: Triggers Cheat Sheet

Creating a trigger

CREATE TRIGGER trigger_name
{ NO CASCADE BEFORE | AFTER }
{INSERT [OR] | UPDATE [OR] | DELETE}[OF col_name]
ON table_name
[REFERENCING OLD AS o NEW AS n]
[FOR EACH ROW]
Statement

Deleting a trigger

ij> Drop trigger tigger_name;

Leave a Reply

Your email address will not be published. Required fields are marked *