*** DRAFT ***

SQLite Requirement Matrix Details
lang_droptrigger.html

Index Summary Markup Original


R-27439-37342-28703-42230-39604-28628-32488-41962 tcl slt th3 src

Canonical usage: syntax/drop-trigger-stmt.html

/* IMP: R-27439-37342 */
# EVIDENCE-OF: R-27439-37342 -- syntax diagram drop-trigger-stmt

R-61172-15671-64149-04052-46334-28337-33946-53778 tcl slt th3 src

The DROP TRIGGER statement removes a trigger created by the CREATE TRIGGER statement.

slt/slt_lang_droptrigger.test:21   tcl/e_droptrigger.test:99

/* IMP: R-61172-15671 */
# EVIDENCE-OF: R-61172-15671 The DROP TRIGGER statement removes a
# trigger created by the CREATE TRIGGER statement.

R-50239-29811-49313-60687-55127-24042-57114-25810 tcl slt th3 src

Once removed, the trigger definition is no longer present in the sqlite_master (or sqlite_temp_master) table and is not fired by any subsequent INSERT, UPDATE or DELETE statements.

tcl/e_droptrigger.test:130

/* IMP: R-50239-29811 */
# EVIDENCE-OF: R-50239-29811 Once removed, the trigger definition is no
# longer present in the sqlite_master (or sqlite_temp_master) table and
# is not fired by any subsequent INSERT, UPDATE or DELETE statements.

R-37808-62273-24906-47503-60125-44409-00514-33279 tcl slt th3 src

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

slt/slt_lang_droptrigger.test:41   tcl/e_droptrigger.test:195

/* IMP: R-37808-62273 */
# EVIDENCE-OF: R-37808-62273 Note that triggers are automatically
# dropped when the associated table is dropped.