The DROP TRIGGER statement is used to drop a trigger from the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Prerequisites
The trigger must be in the current user's schema, or the user must have the ALTER ANY TRIGGER system privilege.
To drop a trigger on a DATABASE in another user's schema, the user must have the ADMINISTER DATABASE TRIGGER system privilege.
Syntax
The syntax for 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 the current user's 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;