Example Of

Example of `CREATE OR ALTER TRIGGER`

Creating a new trigger if it does not exist or altering it if it does exist

CREATE OR ALTER 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

`DROP TRIGGER`

Drops a trigger

Available in

DSQL, ESQL

Syntax

DROP TRIGGER trigname

Table 1. `DROP TRIGGER` Statement Parameter
Parameter	Description
trigname	Trigger name

The DROP TRIGGER statement drops (deletes) an existing trigger.

Example Of

Example of CREATE OR ALTER TRIGGER

DROP TRIGGER

Example of `CREATE OR ALTER TRIGGER`

`DROP TRIGGER`