DROP TRIGGER Statement

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

Topics:

Prerequisites
Syntax
Semantics
Example
Related Topics

Prerequisites

The trigger must be in your own 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.

Topics:

Syntax

drop_trigger::=

Description of the illustration drop_trigger.gif

Semantics

schema

The name of the schema containing the trigger. The default is your own schema.

trigger

The name of the trigger to be dropped.

Example

Dropping a Trigger: Example This statement drops the salary_check trigger in the schema hr:

DROP TRIGGER hr.salary_check;