Lines Matching refs:TRIGGER

31     CREATE TEMP TRIGGER main.r1 AFTER INSERT ON t1 BEGIN
38     CREATE TRIGGER not_a_db.r1 AFTER INSERT ON t1 BEGIN
51       CREATE TRIGGER r1 AFTER UPDATE OF x ON t1 BEGIN
54       CREATE TRIGGER r2 AFTER UPDATE OF y ON t1 BEGIN
89     CREATE TRIGGER t2r1 AFTER INSERT ON t2 BEGIN SELECT 1; END;
90     CREATE TRIGGER t2r2 BEFORE INSERT ON t2 BEGIN SELECT 1; END;
91     CREATE TRIGGER t2r3 AFTER UPDATE ON t2 BEGIN SELECT 1; END;
92     CREATE TRIGGER t2r4 BEFORE UPDATE ON t2 BEGIN SELECT 1; END;
93     CREATE TRIGGER t2r5 AFTER DELETE ON t2 BEGIN SELECT 1; END;
94     CREATE TRIGGER t2r6 BEFORE DELETE ON t2 BEGIN SELECT 1; END;
95     CREATE TRIGGER t2r7 AFTER INSERT ON t2 BEGIN SELECT 1; END;
96     CREATE TRIGGER t2r8 BEFORE INSERT ON t2 BEGIN SELECT 1; END;
97     CREATE TRIGGER t2r9 AFTER UPDATE ON t2 BEGIN SELECT 1; END;
98     CREATE TRIGGER t2r10 BEFORE UPDATE ON t2 BEGIN SELECT 1; END;
99     CREATE TRIGGER t2r11 AFTER DELETE ON t2 BEGIN SELECT 1; END;
100     CREATE TRIGGER t2r12 BEFORE DELETE ON t2 BEGIN SELECT 1; END;
101     DROP TRIGGER t2r6;
116   catchsql { DROP TRIGGER t2r5 }