SQL Anywhere Studio Help
Adaptive Server Anywhere Help
Introduction to property sheets
Trigger property sheet
The General tab of the Trigger property sheet has the following components:
Name Shows the name of the trigger.
Type Shows the type of object.
Table Shows the table the trigger is associated with.
Dialect Shows the SQL dialect in which the code was last saved, either Watcom-SQL or Transact-SQL.
Events Shows which kind of event, Insert, Delete, Update, or Update Columns, causes the trigger to execute.
Timing Shows whether the trigger executes before or after the event. Row-level triggers can also have SQL Remote conflict timing, which executes before UPDATE or UPDATE OF column-lists events.
Level Shows whether the trigger is a row-level trigger or a statement-level trigger.
Order For triggers in the table that execute for the same kind of event with the same timing, the number determines the order in which these triggers fire.
Comment Provides a place for you to type a text description of the trigger. For example, you could use this area to describe the trigger's purpose in the system.
Procedure and trigger overview
Using Procedures, Triggers, and Batches