April 10th, 2013 
Jijo K Jose Drop a Trigger
The syntax for a dropping a Trigger is:
DROP TRIGGER trigger_name;
Disable a Trigger
The syntax for a disabling a Trigger is:
ALTER TRIGGER trigger_name DISABLE;
Disable all Triggers on a table
The syntax for a disabling all Triggers on a table is:
ALTER TABLE table_name DISABLE ALL TRIGGERS;
Enable a Trigger
The syntax for a enabling a Trigger is:
ALTER TRIGGER trigger_name ENABLE;
Enable all Triggers on a table
The syntax for a enabling all Triggers on a table is:
ALTER TABLE table_name ENABLE ALL TRIGGERS;
