Enabled and Disabled Trigger Modes

This section discusses enabled and disabled triggers. A trigger can be in an enabled or disabled mode:

An enabled trigger executes its trigger body if a triggering statement is entered and the trigger restriction (if any) evaluates to TRUE.
A disabled trigger does not execute its trigger body, even if a triggering statement is entered and the trigger restriction (if any) evaluates to TRUE.

Disable a trigger if you do not want the trigger to execute, for example during maintenance activities on the database.