EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Triggers


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

 

 

Creating Triggers

 

To create a new trigger:

  • 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

 

To drop a trigger:

  • 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.