Creating and using triggers

A trigger is a set of actions that run after you insert, update, or delete data. Triggers are created on tables. You can use triggers to enforce business rules for data, audit data, or validate data.

There are a few different types of DML triggers:

• BEFORE INSERT: This causes the trigger to run some logic before you insert data into the table.
• AFTER INSERT: This causes the trigger to run some logic after you insert data into the table.
• BEFORE UPDATE: This causes the trigger to run some logic before you update data in the table.
• AFTER UPDATE: This causes the trigger to run some logic after you update data in the table.
• BEFORE DELETE: This causes the trigger to run some logic before you delete data from the table.
• AFTER DELETE: This causes the trigger to run some logic after you delete data from the table.

Additionally, you can create multiple triggers...