SQLite里的SQL
SQL As Understood By SQLite

[Top]

DROP TRIGGER

drop-trigger-stmt: 隐藏

DROP TRIGGER语句用来删除一个由CREATE TRIGGER语句创建的触发器。一旦被移除，这个触发器的定义就不会再出现在sqlite_master（或sqlite_temp_master）表中了，并且不会被后续的INSERT、UPDATE或DELETE语句触发。
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_master (or sqlite_temp_master) 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.