The role of the trigger
The trigger has the following effects:
1. The data can be forcibly verified or converted before being written to the data table.
2. When an error occurs in the trigger, the result of the transaction will be cancelled.
3. Some database management systems can use triggers for data definition language (DDL), called DDL triggers.
4. The INSTEAD OF can be replaced according to specific conditions.