SQLite DROP TRIGGER

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

Syntax:

snippet

DROP TRIGGER trigger_name;

Example:

See the given example. It has 5 triggers:

Let's drop the trigger named "audit_log".

snippet

DROP TRIGGER audit_log;

Now you can see "audit_log" is dropped.

Related Tutorial

1 SQLite Triggers

2 SQLite Trigger: AFTER INSERT/ BEFORE INSERT

3 SQLite Trigger: AFTER UPDATE

4 SQLite Trigger AFTER DELETE

5 SQLite DROP TRIGGER

Try it

Contents +