UPDATE Event

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > CREATE TRIGGER >

UPDATE Event

UPDATE events (and SELECT events) can include an optional column list.

UPDATE Event:
 
|--UPDATE--+----------------+--ON--table------------------------|
           |     .-,------. |
           |     V        | |
           '-OF----column-+-'

Element	Description	Restrictions	Syntax
column	Column that activates the trigger	Must exist in the triggering table	Identifier, p. Identifier
table	Name of the triggering table	Must exist in the database	Identifier, p. Identifier

If you define more than one Update trigger on the same table, the column list is required, and the column lists for each trigger must be mutually exclusive. If you omit the OF column list, updating any column of table activates the trigger.

The OF column clause is not valid for an INSTEAD OF trigger on a view.

An UPDATE on the triggering table can activate the trigger in two cases:

The UPDATE statement references any column in the column list.
The UPDATE event definition has no OF column list specification.

Whether it updates one column or more than one column from the column list, a triggering UPDATE statement activates the Update trigger only once.