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. |