Triggers Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Triggers Editor lets you modify the trigger body of a trigger and change its enabled/disabled status.

To edit a trigger:

  1. Open an editor on the trigger. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you view the basic identifying properties of the trigger and its parent view or table: Parent Type, Parent Owner, Parent Name, Owner, Name, Create Date, Fire On Insert, Fire On Update, and Fire On Delete. For details on these properties, see Triggers (Sybase ASE) - Properties. This panel also lets you specify whether the trigger is Enabled.

Definition

Lets you modify the CREATE TRIGGER body for a trigger. To modify a trigger, the trigger must be dropped then recreated. NOTE: If the Definition tab for the trigger shows a Source text for this compiled object is hidden message, source text for this compiled object has been hidden. For more information, see Hide Text.

Dependencies

For details on using this tab, see Working with Object Dependencies.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes