Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.
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;