Enabling And Disabling Triggers

An enabled trigger executes the trigger body if the triggering statement is issued.  By default the triggers are enabled. A disabled trigger does not execute the trigger body even if triggering statements are issued. 

The syntax for disabling a trigger is:

ALTER TRIGGER <TRIGGER_NAME> { DISABLE | ENABLE };

ALTER TABLE <TABLE_NAME>{ DISABLE | ENABLE } ALL TRIGGERS;

 Dropping of a trigger

Drop Trigger <Trigger_Name>;