Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_droptrigger.html

Index Summary Markup Original


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-04950-25529-49153-37444-18478-06220-49910-01329 tcl slt th3 src

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.

tcl/e_droptrigger.test:130

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

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.