Use this statement to remove a trigger from the database.

Syntax

DROP TRIGGER [ IF EXISTS ] [ owner.] [ table-name.]trigger-name

Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP statement attempts to remove a database object that does not exist.

Permissions

A user with ALTER permissions on the table can execute DROP TRIGGER.

Side effects

Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.

See also

• CREATE TRIGGER statement
• ALTER TRIGGER statement
• ROLLBACK TRIGGER statement

Standards and compatibility

Example

Drop MyTrigger from the database. If the trigger does not exist, an error is returned.

DROP TRIGGER MyTrigger;