check if trigger exists (verificar se trigger existe) - Firebird

select_trigger_firebird

SELECT
  RDB$TRIGGER_NAME FROM RDB$TRIGGERS
WHERE 
  RDB$TRIGGER_NAME = 'triggerName'

using_execute_block

execute block
as
    declare variable stmt VARCHAR(100) = 'DROP TRIGGER TRIGGER_NAME;';
begin
    if (exists (SELECT RDB$TRIGGER_NAME FROM RDB$TRIGGERS WHERE RDB$TRIGGER_NAME = 'TRIGGER_NAME')) then
    begin
        execute statement stmt;
    end
end;