Skip to content

lang_droptrigger.md

Latest commit

 

History

History
20 lines (17 loc) · 738 Bytes

lang_droptrigger.md

File metadata and controls

20 lines (17 loc) · 738 Bytes
title DROP TRIGGER
description The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement.
statement DROP TRIGGER IF EXISTS validate_artist_name;
customClass sqlite-doc
category reference
status publish

The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement. Once removed, the trigger definition is no longer present in the sqlite_schema (or sqlite_temp_schema) table and is not fired by any subsequent INSERT, UPDATE or DELETE statements.

Note that triggers are automatically dropped when the associated table is dropped.