We can destroy a trigger in two ways −
With the help of the DROP statement, we can destroy a trigger explicitly. It can be understood with the help of the following example −
mysql> DROP Trigger before_inser_studentage1; Query OK, 0 rows affected (0.05 sec)
A trigger will be destroyed implicitly if the table with which it is associated is destroyed or if the database which it is associated is destroyed.