Exemples
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
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
Suppression d’un déclencheur existant.
DSQL, ESQL
DROP TRIGGER trigname
Paramètre | Description |
---|---|
trigname |
Nom du déclencheur. |
L’instruction `DROP TRIGGER' supprime un trigger existant.