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.

Prérequis

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.

Résultat

The trigger is removed from the database.

Suivant

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

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0