You can use the DROP TRIGGER statement to drop a trigger.
Before you drop a trigger, make sure that you have the TRIGGER privilege.
The syntax is as follows:
DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name
The schema_name parameter is optional. If the schema_name parameter is omitted, the trigger is dropped from the default schema. To execute the DROP TRIGGER statement, you must have the TRIGGER privilege on the table associated with the trigger.
You can use the IF EXISTS clause so that a note is returned instead of an error if the trigger does not exist.
If a table is dropped, its triggers are also dropped.
Here is an example:
obclient> DROP TRIGGER IF EXISTS test_trg;
Query OK, 0 rows affected