SQL$HELP72.HLB  —  User Supplied Names, Trigger Names
    You name a trigger in the CREATE TRIGGER statement. A trigger
    name must be unique within a schema of a multischema database or
    unique within a nonmultischema database.

    A trigger defines the actions to occur before or after a
    specified table is updated (by a write operation such as an
    INSERT, DELETE, or UPDATE statement). A trigger can be thought
    of as a rule on a single table, which takes effect at a specific
    time for a particular type of update and causes one or more
    triggered actions to be performed.

    With triggers, you can define useful actions such as:

    o  Cascading deletes

       Deleting a row from one table causes additional rows to be
       deleted from other tables that are related to the first table
       by key values.

    o  Cascading updates

       Updating a row in one table causes additional rows to be
       updated in other tables that are related to the first table
       by key values. These updates are usually limited to the key
       values themselves.

    o  Summation updates

       Updating a row from one table causes a value in a row of
       another table to be updated by being increased or decreased.

    o  Hidden deletes

       Causing rows to be deleted from a table by moving them to a
       parallel table that is not used by the database.

    o  Audit log

       Records when and by whom a row is inserted, updated, or
       deleted.
Close Help