DROP TRIGGER Statement

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

drop_trigger ::=

Semantics

schema

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

trigger

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; 

Related Topics

• "ALTER TRIGGER Statement"

• "CREATE TRIGGER Statement"