Trigger template item properties

Chapter 6 Building Triggers and Procedures

Trigger template item properties

You can modify an object's properties from its property sheet. To open a trigger template item property sheet, access it via the List of User-Defined Trigger Template Items List or the DBMS Properties window. The following sections detail the property sheet tabs that contain the properties most commonly entered for trigger template items.

The General tab contains the following properties:

Property	Description
Name	The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users
Code	The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces
Comment	Descriptive label for the template item
DBMS	Current DBMS

The following tabs are also available:

Definition - allows you to enter the SQL code for the template item. For information about the tools available, see SQL Code Definition Toolbars.
Declaration - contains the declaration for the template item in trigger scripts. For information about the tools available, see SQL Code Definition Toolbars.