This MariaDB tutorial explains how to use the DROP TRIGGER statement to drop a trigger in MariaDB with syntax and examples.
Once you have created a trigger in MariaDB, you might find that you need to remove it from the database. You can do this with the DROP TRIGGER statement.
The syntax to a drop a trigger in MariaDB in MariaDB is:
DROP TRIGGER trigger_name;
Parameters or Arguments
The name of the trigger that you wish to drop.
- See also how to create AFTER DELETE, AFTER INSERT, AFTER UPDATE, BEFORE DELETE, BEFORE INSERT, and BEFORE UPDATE triggers.
Let's look at an example of how to drop a trigger in MariaDB.
DROP TRIGGER contacts_before_insert;
This example uses the ALTER TRIGGER statement to drop the trigger called contacts_before_insert.