Online Documentation for SQL Manager for DB2

Triggers


Table triggers are managed within the Triggers tab of 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;
  • define 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 context menu item, or simply double-click the trigger;
  • edit the trigger properties using the Trigger Editor 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 context menu item;
  • confirm dropping in the dialog window.