Enable/Disable all Triggers on a Firebird database

enable_disable_all_triggers.sql

-- Disable all Triggers

update 
    rdb$triggers 
set 
    rdb$trigger_inactive = 1
where 
    rdb$trigger_source is not null 
    and ((rdb$system_flag = 0) 
    or (rdb$system_flag is null))


-- Enable all Triggers

update 
    rdb$triggers 
set 
    rdb$trigger_inactive = 0
where 
    rdb$trigger_source is not null 
    and ((rdb$system_flag = 0) 
    or (rdb$system_flag is null))

You can use these SQL commands to activate/deactivate single triggers:

    alter trigger TRIGGER_NAME inactive;
    alter trigger TRIGGER_NAME active;

This sentence fails if you have CHECKs trigger, for this case use:

update rdb$triggers 
set rdb$trigger_inactive = 1
where 
    rdb$trigger_source is not null 
    and (coalesce(rdb$system_flag,0) = 0) 
    and rdb$trigger_source not starting with 'CHECK'

Thanks @cerezo!

Thank you very much

Hi
does not work in FB3
update rdb$triggers set rdb$trigger_inactive = 1 where rdb$trigger_source is not null and (coalesce(rdb$system_flag,0) = 0) and rdb$trigger_source not starting with 'CHECK'

**
SET TERM ^ ;
EXECUTE BLOCK
AS
DECLARE VARIABLE NOMTABLE varchar(100);
DECLARE VARIABLE REQ1 Varchar(100);
BEGIN
for select x.RDB$TRIGGER_NAME from rdb$triggers x where
rdb$trigger_source is not null and (coalesce(rdb$system_flag,0) = 0)
and rdb$trigger_source not starting with 'CHECK' into :NOMTABLE
do
begin
NOMTABLE=trim(NOMTABLE);
req1= 'ALTER TRIGGER ' || :NOMTABLE || ' INACTIVE;';
execute statement req1;
end
END^
SET TERM ; ^
**