*** DRAFT ***

SQLite Requirement Matrix Details
lang_droptrigger.html

Index Summary Markup Original


R-35418-18016-10993-27937-35322-13021-34119-58359 tcl slt th3 src

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

th3/cov1/trigger03.test:101

/* IMP: R-35418-18016 */
# EVIDENCE-OF: R-35418-18016 -- 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.