You can use the DROP TRIGGER statement to drop a trigger from the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
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
The syntax of drop_trigger is as follows:
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;