Firebird: Ativando/Destivando todas as triggers do banco

0

Posted on : 28-06-2012 | By : Paulo H Oliveira | In : Banco de Dados, Firebird

Segue abaixo dos SQL’s para desabilitar/habilitar todas as triggers do banco de dados:

--desabilitar todas as triggers do banco
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))

--habilita todas as triggers do banco
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))

Dica postada por Daniel Pohren na lista da FireBase:

Compartilhe :

  • Stumble upon
  • twitter

Escreva um comentário

Security Code: