CREATE TABLE TEST_TABLE (
    ID         INTEGER NOT NULL,
    NEW_FIELD  INTEGER
);

CREATE TABLE TEST_TABLE_2 (
    ID  DOM$KEY NOT NULL
);



SET TERM ^ ;

/* Trigger: TEST_TABLE_2_AI0 */
CREATE OR ALTER TRIGGER TEST_TABLE_2_AI0 FOR TEST_TABLE_2
ACTIVE AFTER INSERT POSITION 0
AS
BEGIN
    INSERT INTO TEST_TABLE(id) values(new.id);
END
^

SET TERM ; ^

INSERT INTO TEST_TABLE (ID, NEW_FIELD)
                VALUES (1, 1);
INSERT INTO TEST_TABLE (ID, NEW_FIELD)
                VALUES (2, 2);
INSERT INTO TEST_TABLE (ID, NEW_FIELD)
                VALUES (3, 3);

INSERT INTO TEST_TABLE_2(ID) VALUES (6)

ALTER TABLE TEST_TABLE ALTER NEW_FIELD SET NOT NULL

INSERT INTO TEST_TABLE_2(ID) VALUES (6)

ID	NEW_FIELD
1	1
2	2
3	3
6