SET TERM ^ ;

CREATE OR ALTER trigger tbapi_integracao_b01d for tbapi_integracao
active before delete position 0
AS
BEGIN
   IF(OLD.ID > 0) THEN
   BEGIN
      DELETE FROM TBPAGAMENTO_CONDICAO_API         T WHERE T.API_ID = OLD.ID;
      DELETE FROM TBPAGAMENTO_FORMA_API            T WHERE T.API_ID = OLD.ID;

      DELETE FROM TBAPI_INTEGRACAO_AGD             T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_AGENDAMENTO     T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_COR             T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_MOD             T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_PRO             T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_TAM             T WHERE T.API_INTEGRACAO_ID = OLD.ID;
      DELETE FROM TBAPI_INTEGRACAO_TOKEN           T WHERE T.API_INTEGRACAO_ID = OLD.ID;
   END
END
^

SET TERM ; ^