ASA SQL User's Guide
  Using Procedures, Triggers, and Batches
    Introduction to triggers

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.

To delete a trigger (SQL)

1. Connect to a database.

2. Execute a DROP TRIGGER statement.

Example 

The following statement removes the trigger mytrigger from the database:

DROP TRIGGER mytrigger

For more information, see DROP statement.