background image
<< Compiling Triggers | Working in a Global Environment >>
<< Compiling Triggers | Working in a Global Environment >>

Dropping Triggers

Creating and Using Triggers
5-10 Oracle Database 2 Day Developer's Guide
Dropping Triggers
When you need to delete a trigger, use the
DROP TRIGGER
statement, as shown in
Example 5­16
.
Example 5­16 Dropping a Trigger
DROP TRIGGER eval_change_trigger;
After you drop a trigger, you can drop the dependent object that are no longer needed
by the application.
See Also:
Oracle Database PL/SQL Language Reference for details about
compiling triggers
See Also:
Oracle Database SQL Language Reference for information about the
DROP TRIGGER
statement