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.