Dropping Triggers

By now the syntax for dropping a trigger should be apparent. To drop a trigger, use the DROP TRIGGER statement, as seen here:

• Input

DROP TRIGGER newproduct;

• Analysis

Triggers cannot be updated or overwritten. To modify a trigger, it must be dropped and re-created.