Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 25 of 30
To remove a database trigger from the database.
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.
The following statement drops the REORDER
trigger in the schema RUTH
:
DROP TRIGGER ruth.reorder;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|