简单触发器的例子

 -- 首先，创建两个表T1和T2
 
CREATE TABLE T1 (a INTEGER, b CHAR(10));
CREATE TABLE T2 (c CHAR(10), d INTEGER);
 
-- 在表T1创建插入后触发器，触发器实现插入T2
 
CREATE TRIGGER trig1
    AFTER INSERT ON T1
    REFERENCING NEW AS newRow
    FOR EACH ROW
    WHEN (newRow.a <= 10)
    BEGIN
        INSERT INTO T2 VALUES(:newRow.b, :newRow.a);
    END trig1;