You can use the DROP TRIGGER statement to drop a trigger from the database.
Prerequisites
The trigger must be located in your own schema, or you must have the ALTER ANY TRIGGER system privilege.
To drop a trigger from the schema (DATABASE) of other users, you must have the ADMINISTER DATABASE TRIGGER system privilege.
Syntax
Syntax of drop_trigger:
DROP TRIGGER [ schema. ] trigger ;
Semantics
| Syntax | Keyword or syntax node | Description |
|---|---|---|
| drop_trigger | schema | The name of the schema where the trigger is located. The default value is your schema. |
| drop_trigger | trigger | The name of the trigger to be dropped. |
Examples
Drop the trigger named del_new_region.
DROP TRIGGER del_new_region;