<< Click to Display Table of Contents >>

Schema Triggers

Top Previous Next

The upper part of the window contains a list of all schema triggers:

Trigger name

Trigger Type, i.e. when the trigger fires - BEFORE/AFTER

Event

Status (Enabled/Disabled)

Time stamps of creation and last DDL time

Trigger Owner

The following context operations are available:

TriggerCreate

Create

Shows a modal dialog for creating a new trigger. You can specify when the trigger should fire. The body will be empty (NULL) and can be changed in the editor window.

07_Drop

Drop

Drops the selected trigger.

Compile

Compile

Compiles the trigger.

 

Compile debug

Compiles the trigger with debug options

Enable

Enable

Enables the trigger.

DISABLE

Disable

Disables the trigger.

There are two detail views below the list of triggers that can be selected.

The first tab displays the trigger body. You can modify and compile the text. Syntax errors will be displayed below the editor.

The second tab displays a list of objects depending on the trigger.