Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Stored procedures, triggers, batches, and user-defined functions » Triggers

 

Dropping a trigger

Use Sybase Central to drop a trigger from your database when you no longer need it.

Prerequisites

You must be the owner of the trigger or have one of the following system privileges:

  • DROP ANY TRIGGER
  • DROP ANY OBJECT
 Task
  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Triggers.

  3. Select the trigger and click Edit » Delete.

  4. Click Yes.

Results

The trigger is removed from the database.

Next

Dependent database object must have their definitions modified to remove references to the dropped trigger.

 See also