Triggers

From DBArtisan
Jump to: navigation, search

Go Up to Supported Objects

Triggers are a special type of procedure that automatically fire when defined data modification operations (insert, update, or delete) occur on a target table or view. Trigger support differs by DBMS type, but in general offers options such as:

  • Standard INSERT/DELETE/UPDATE event support
  • BEFORE/AFTER timing control
  • Row/statement trigger type control
  • INSTEAD OF triggers
  • Compound triggers
  • Enabled/disabled status options

Creating and editing

Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

DB2 LUW DB2 z/OS ORCL PSTGRS * SQL SVR SYB ASE

Change Status

Compile

Drop

Extract

Hide Text

Migrate

Report

Rename

Transfer Ownership