<< Click to Display Table of Contents >>

Database Triggers

Top Previous Next

The upper part of the window contains a list of all database triggers in the database—that is, those that are dependent on events rather than DML operations:

Trigger name

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

Event

Status (Enabled/Disabled)

Time stamps of creation and last DDL operation

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); you can change it 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.

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

The second tab sheet displays a list of objects that depend on the trigger.