Online Documentation for SQL Manager for InterBase/Firebird

Triggers


Table triggers are managed within the Triggers tab of the Table Editor.

 

Creating Triggers

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the tab area and select the New Trigger... context menu item, or press the Ins key;
  • edit the trigger properties using the Trigger Editor dialog.

 

Editing Triggers

To edit an existing trigger:

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the trigger and select the Edit Trigger <trigger_name>... context menu item, or simply double-click the trigger;
  • edit the trigger properties using the Trigger Editor dialog.

To change the name of a trigger:

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the trigger to rename and select the Rename Trigger <trigger_name>... item from the context menu;
  • edit the trigger name using the Rename Object... dialog.

 

Dropping Triggers

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the trigger and select the Drop Trigger <trigger_name> context menu item, or press the Del key;
  • confirm dropping in the dialog window.