Drop a trigger

This topic describes how to drop a trigger.

Syntax

DROP TRIGGER [IF EXISTS] [database_name.]trigger_name;

Parameters

Example

1. View the del_new_region trigger.

   obclient> SELECT * FROM information_schema.triggers WHERE TRIGGER_NAME= 'del_new_region'\G;
   *************************** 1. row ***************************
              TRIGGER_CATALOG: def
               TRIGGER_SCHEMA: ny
                 TRIGGER_NAME: del_new_region
           EVENT_MANIPULATION: DELETE
         EVENT_OBJECT_CATALOG: def
          EVENT_OBJECT_SCHEMA: ny
           EVENT_OBJECT_TABLE: regions
                 ACTION_ORDER: 0
             ACTION_CONDITION: NULL
             ACTION_STATEMENT: TRIGGER del_new_region
            BEFORE DELETE ON regions
          FOR EACH ROW
      BEGIN
         INSERT INTO reg_his(region_id , region_name)
              VALUES( :old.region_id, :old.region_name);
      END
           ACTION_ORIENTATION: ROW
                ACTION_TIMING: BEFORE
   ACTION_REFERENCE_OLD_TABLE: NULL
   ACTION_REFERENCE_NEW_TABLE: NULL
     ACTION_REFERENCE_OLD_ROW: OLD
     ACTION_REFERENCE_NEW_ROW: NEW
                      CREATED: NULL
                     SQL_MODE: STRICT_ALL_TABLES,NO_ZERO_IN_DATE
                      DEFINER: 'root'@'%'
         CHARACTER_SET_CLIENT: utf8mb4
         COLLATION_CONNECTION: utf8mb4
           DATABASE_COLLATION: utf8mb4
   1 row in set
   

2. Drop the del_new_region trigger.

   obclient> DROP TRIGGER del_new_region;
   Query OK, 0 rows affected
   

3. View the del_new_region trigger again.

   obclient> SELECT * FROM information_schema.triggers WHERE TRIGGER_NAME= 'del_new_region'\G
   Empty set