Online Documentation for SQL Manager for InterBase/Firebird

Managing triggers


The Triggers tab is provided for managing table triggers. Double-click a trigger to open Trigger Editor for editing the trigger.

 

Right-click the area to display the context menu allowing you to create new, edit, rename, or drop the selected trigger. Using the menu you can also set the trigger active/inactive, and open the selected trigger in a separate Trigger Editor.

 

Triggers management tools are also available through the Navigation bar of Table Editor.

 

Table Editor - Managing triggers

 

The Triggers list provides the following attributes of each trigger of the view:

Trigger Name

Position

Active

Description

 

On this tab all triggers are grouped into categories:

  • Before Insert
  • After Insert
  • Before Update
  • After Update
  • Before Delete
  • After Delete

 

The trigger definition is displayed in the Trigger DDL window.

 

Use the context menu or items on a toolbar to manage triggers:

iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)

iconSetTriggerInactive set trigger active/inactive

iconOpenInSeparateEditor open selected trigger in a Trigger Editor

 

For details see Triggers.