What is Trigger


A trigger is a special type of database object.

It automatically executes when a specific event occurs.

Triggers run inside the database engine.

Triggers are activated by database events.

Common events include INSERT, UPDATE, and DELETE.

They do not require manual execution.

Triggers are mainly used to enforce business rules.

They can maintain logs and validations.

Triggers increase automation.

Triggers execute automatically when table data changes.

They cannot be called directly like procedures.

Execution happens internally.

Triggers are powerful database tools.

They must be used carefully.

Improper triggers can affect performance.