Drop a trigger

You can execute the DROP TRIGGER statement to drop a trigger.

Before you drop a trigger, make sure that you have privileges on the associated table of this trigger. If you drop a table, the trigger associated with this table is also dropped.

Before you drop a trigger, make sure that you have the TRIGGER privilege.

The syntax for dropping a trigger is as follows:

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

The parameters are described as follows:

• IF EXISTS: indicates that if the specified trigger exists, the system drops the trigger.

• database_name: the database name. If it is not specified, the specified trigger is dropped from the current database.

Here is an example:

obclient> DROP TRIGGER test.test_trg;