A trigger is a special type of stored procedure that automatically executes in response to certain events.

• Triggers are used to enforce business rules or to perform complex calculations.

• Syntax: CREATE ...read more

create trigger [trigger_name]: Creates or replaces an existing trigger with the trigger_name. [before | after]: This specifies when the trigger will be executed. {insert | update | delete}: This speci...read more