Trigger and DBMS Trigger Properties

To view or edit a trigger's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

Owner

Specifies the user who is the owner of the object. This is usually its creator. Use the tools to the right of the list to create, browse for, or view the properties of the currently selected object.

Table

[Table or view triggers only] Specifies the table to which the trigger belongs.

Scope

[DBMS triggers only] Specifies the scope of the DBMS trigger. You can choose either Schema or Database, and this choice will control the types of events that you can select in the DBMS trigger definition.

Generate

Specifies to generate the trigger.

User-defined

[Read-only] Specifies that the trigger definition has been modified. You modify a trigger definition when you change the trigger template script in the Definition tab of the trigger

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

Definition Tab

This tab allows you to enter code for the trigger. For information about the tools available on the toolbar, see Writing SQL Code in PowerDesigner. The following properties are available:

Property

Description

Template

Specifies the template on which the trigger is based (see Trigger Templates). The User-defined button is automatically depressed when you modify the definition of a trigger. Click the button to release it and restore the template trigger definition.

Time

Specifies when the trigger will fire in relation to the associated event. The content of the list depends on the values defined in the trigger template and in the Time entry in the Trigger category of the DBMS.

Event

Specifies the event that will cause the trigger to fire. Click the ellipsis tool to the right of this field to select multiple events (see Defining Triggers with Multiple Events)

For table and view triggers, this field is a list, the content of which depends on the values defined in the trigger template and in the Event entry in the Trigger category of the DBMS. You can add your own events to this entry and they will appear in this list.

For DBMS triggers, this field allows you to enter any text.

Order

[table and view triggers only] Specifies the firing order of trigger.

The following tabs are also available: