Answers

Question and Answer:

  Home  Firebird

⟩ How to deactivate triggers?

You can use these SQL commands:

ALTER TRIGGER trigger_name INACTIVE;

ALTER TRIGGER trigger_name ACTIVE;

Most tools have options to activate and deactivate all triggers for a table. For example, in FlameRobin, open the properties screen for a table, click on Triggers at top and then Activate or Deactivate All Triggers options at the bottom of the page.

 155 views

More Questions for you: