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

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.

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

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

• CREATE TRIGGER statement
• ALTER TRIGGER statement
• ROLLBACK TRIGGER statement
• Dropping triggers

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

DROP TRIGGER MyTrigger;