The Firebird 5.0 Language Reference | RECREATE TRIGGER | Example Of RECREATE TRIGGER

Example of `RECREATE TRIGGER`

Creating or recreating the set_cust_no trigger.

RECREATE TRIGGER set_cust_no
ACTIVE BEFORE INSERT ON customer POSITION 0
AS
BEGIN
  IF (NEW.cust_no IS NULL) THEN
    NEW.cust_no = GEN_ID(cust_no_gen, 1);
END

See also

[fblangref50-ddl-trgr-create], [fblangref50-ddl-trgr-drop], [fblangref50-ddl-trgr-crtalter]