Drawing triggers

Trigger is procedure that is stored in a relational database. It will be executed when a table is modified. A typical use of database trigger is for restricting access to specific data.

Create a triggers shape

Click Triggers from diagram toolbar and drag it on the diagram pane.

Create triggers shape
Create triggers shape

After specify the name for the newly created triggers, press Enter.

Rename trigger shape
Rename a triggers shape

Create a new trigger

Right click the triggers and select New Trigger from the pop-up menu, or press Alt+Shift+T.

Create a new trigger
Create a new trigger

In Triggers Specification dialog box, specify the create statement.

Specify the create statement in Trigger Specification dialog box
Specify the create statement in Trigger Specification dialog box

Move or duplicate triggers to another trigger container

  1. Select the trigger to move or duplicate.
    Selecting triggers to move or duplicate
    Selecting triggers to move or duplicate
  2. Drag over the target trigger container.
    Dragging trigger towards the target triggers container
    Dragging trigger towards the target triggers container
  3. If you want to duplicate the triggers, press on the Ctrl key and release the mouse button. If you want to move them from source to target trigger container, just release the mouse button.
    Triggers are moved
    Triggers are moved