Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » SQL Anywhere Plug-in Help » Introduction to SQL Anywhere property sheets

Table property sheet: Check Constraint tab Next Page

Trigger property sheet: General tab

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.

View    Shows the view 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, after, or instead of the event. Row-level triggers can also have SQL Remote conflict timing, which executes before UPDATE or UPDATE OF column-list events.

Level    Shows whether the trigger is a row-level trigger or a statement-level trigger.

Order    Shows a number that determines the order in which these triggers fire, for triggers in the table that execute for the same kind of event with the same timing. The order can not be set for an INSTEAD OF trigger. If Timing is set to INSTEAD OF, this property does not appear.

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.

See also