15.19 DROP TRIGGER Statement

The DROP TRIGGER statement drops a database trigger from the database.

Topics

Prerequisites

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.

Syntax

Semantics

schema

Name of the schema containing the trigger. Default: your schema.

trigger

Name of the trigger to be dropped.

Example

Example 15-39 Dropping a Trigger

This statement drops the salary_check trigger in the schema hr:

DROP TRIGGER hr.salary_check;