Once you create a trigger, it remains in the database until someone explicitly removes it. You must have ALTER permissions on the table associated with the trigger to drop the trigger.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the trigger.
In the left pane, double-click Triggers.
Select the trigger and choose Edit » Delete.
Connect to a database as a user with DBA authority or as the owner of the trigger.
Execute a DROP TRIGGER statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|