15.19 DROP TRIGGER Statement
The DROP
TRIGGER
statement drops a database trigger from the database.
Topics
Prerequisites
The trigger must be in your schema or you must have the DROP
ANY
TRIGGER
system privilege. To drop a trigger on DATABASE
in another user's schema, you must also have the ADMINISTER
DATABASE
TRIGGER
system privilege.
Syntax
drop_trigger ::=
Semantics
schema
Name of the schema containing the trigger. Default: your schema.
trigger
Name of the trigger to be dropped.
Example
Example 15-39 Dropping a Trigger
This statement drops the salary_check
trigger in the schema hr
:
DROP TRIGGER hr.salary_check;
Related Topics