View Triggers

Trigger management includes the creation, modification and deletion of triggers on a database object. A trigger is a special form of stored procedure that executes automatically when a statement that modifies data displayed in a view is executed.

Triggers can only fire against system store tables, but a view can reference multiple tables from the IQ main or system stores. Therefore, triggers that references tables from both stores will fire, but only against system store tables.

• Creating a View Trigger
  Create a new trigger on a view in the system store.
• Deleting a View Trigger
  Delete triggers from a view.
• Generating View Trigger DDL Commands
  Display the data description language SQL code for adding a trigger to a view in the database. The SQL code can be a useful reference and training tool.
• Viewing or Modifying View Trigger Properties
  View or change trigger properties on a view, including the comment and the underlying SQL statement of the trigger.
• View Trigger Privilege Summary
  A list of the system privileges and object permissions required to complete the various view trigger tasks on database objects.