3.11 Managing Triggers
A database trigger is a stored subprogram associated with a database table, view, or event. You can use Object Browser to create, view, edit, compile, download, drop, and disable or enable a trigger.
The trigger can be called once, for example when an event occurs, or many times, for example for each row affected by an INSERT, UPDATE, or DELETE statement.
- Creating a Trigger
Create a trigger using Object Browser. - Viewing a Trigger
Select a trigger from the Object Tree and access tabs in the Object Detail View. - Editing a Trigger
Select a trigger from the Object Tree. - Compiling a Trigger
Select a trigger from the Object Tree and click Save and Compile. - Downloading a Trigger
Select a trigger from the Object Tree and click Download to save the trigger as a file. - Disabling and Enabling a Trigger
Select a trigger from the Object Tree and click Enable or Disable. - Dropping a Trigger
Select a trigger from the Object Tree and click Drop.
Parent topic: Managing Database Objects with Object Browser
3.11.1 Creating a Trigger
Create a trigger using Object Browser.
To create a trigger in Object Browser:
Parent topic: Managing Triggers
3.11.2 Viewing a Trigger
Select a trigger from the Object Tree and access tabs in the Object Detail View.
To view a trigger:
Parent topic: Managing Triggers
3.11.4 Compiling a Trigger
Select a trigger from the Object Tree and click Save and Compile.
To compile a trigger in Object Browser:
Parent topic: Managing Triggers
3.11.5 Downloading a Trigger
Select a trigger from the Object Tree and click Download to save the trigger as a file.
To download a trigger as a file:
Parent topic: Managing Triggers
3.11.6 Disabling and Enabling a Trigger
Select a trigger from the Object Tree and click Enable or Disable.
To disable and enable a trigger in Object Browser:
Parent topic: Managing Triggers
3.11.7 Dropping a Trigger
Select a trigger from the Object Tree and click Drop.
To drop a trigger:
Parent topic: Managing Triggers