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.

Syntax for dropping a trigger:

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

Parameters:

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

• database_name: the database name. This is an optional parameter. If no database is specified, the trigger is dropped from the current database.

Example:

obclient>DROP TRIGGER test.test_trg;