DROP TRIGGER Statement
The DROP TRIGGER statement drops a database trigger from the database.
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.
Name of the schema containing the trigger. Default: your schema.
Name of the trigger to be dropped.
Dropping a Trigger: Example This statement drops the salary_check trigger in the schema hr:
DROP TRIGGER hr.salary_check;