Removes a trigger from the database.
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.
SQL/2008 DROP TRIGGER comprises part of optional SQL language feature T211, "Basic trigger capability", of the SQL/2008 standard. The IF EXISTS clause is a vendor extension.
Drop MyTrigger from the database. If the trigger does not exist, an error is returned.
DROP TRIGGER MyTrigger;