Use this statement to remove 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/2003 Core feature.
Drop MyTrigger from the database. If the trigger does not exist, an error is returned.
DROP TRIGGER MyTrigger;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|