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:

Sqlite Drop trigger 1

Let's drop the trigger named "audit_log".

snippet
DROP TRIGGER audit_log;

Now you can see "audit_log" is dropped.

Sqlite Drop trigger 2
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents