DROP TRIGGER

In SQLite, DROP TRIGGER command is used to drop/ delete trigger from a table.

Syntax:

DROP TRIGGER trigger_name;   

Example:

See the given example. It has 5 triggers:

Let’s drop the trigger named “audit_log”.

DROP TRIGGER audit_log;   

Now you can see “audit_log” is dropped.