15.19 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 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 ::=

Description of the illustration drop_trigger.eps

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; 

Related Topics

• "ALTER TRIGGER Statement"

• "CREATE TRIGGER Statement"