Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
DROP SEQUENCE to ROLLBACK, 6 of 20
Use the DROP
TRIGGER
statement to remove a database trigger from the database.
See Also:
|
The trigger must be in your own schema or you must have the DROP
ANY
TRIGGER
system privilege.
In addition, to drop a trigger on DATABASE
in another user's schema, you must have the ADMINISTER
DATABASE
TRIGGER
system privilege.
drop_trigger::=
drop_trigger
Specify the schema containing the trigger. If you omit schema, Oracle assumes the trigger is in your own schema.
Specify the name of the trigger to be dropped. Oracle removes it from the database and does not fire it again.
DROP
TRIGGER
Example
The following statement drops the order
trigger in the schema oe
:
DROP TRIGGER oe.order;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|