Table Triggers

A trigger is a special form of stored procedure that executes automatically when a statement that modifies data in a table is executed. Trigger management includes creating, modifying and deleting triggers on a database object.

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