SET TERM ^ ;

CREATE OR ALTER trigger ttbcentro_negocio_familia_b02d for tbcentro_negocio_familia
active before delete position 1
AS
BEGIN
    IF (OLD.ID > 0) THEN
        BEGIN
            DELETE FROM TBCENTRO_NEGOCIO_FAMILIA_LINHA T
            WHERE T.CENTRO_NEGOCIO_ID = OLD.CENTRO_NEGOCIO_ID
            AND T.FAMILIA_ID = OLD.FAMILIA_ID;
        END
END
^

SET TERM ; ^