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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Procedures, Triggers, and Batches » Introduction to triggers

Altering triggers Next Page

Dropping triggers

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.

To delete a trigger (Sybase Central)
  1. Open the Triggers folder.

  2. Right-click the desired trigger and choose Delete from the popup menu.

  3. To delete a trigger (SQL)
    1. Connect to a database.

    2. Execute a DROP TRIGGER statement.

    3. Example

      The following statement removes the trigger mytrigger from the database:

      DROP TRIGGER mytrigger;

      For more information, see DROP statement.