Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
Use the DROP
TRIGGER
statement to remove a database trigger from the database.
Prerequisites
The trigger must be in your own 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
Specify the schema containing the trigger. If you omit schema
, then Oracle Database assumes the trigger is in your own schema.
Specify the name of the trigger to be dropped. Oracle Database removes it from the database and does not fire it again.
Example
Dropping a Trigger: Example The following statement drops the salary_check
trigger in the schema hr
:
DROP TRIGGER hr.salary_check;