Editing an ASE Trigger

Edit a trigger to change the name, trigger events, and other properties.

Prerequisites 

Before you can edit a trigger, be sure the data server that contains the trigger is running, and you created and established a connection to the data server.

  1. Expand the table that contains the trigger.
  2. Under the Triggers folder, find the trigger you want to edit, right-click the trigger, and choose Edit.

    The Trigger Editor page opens.

  3. Edit the trigger properties.
    Editor Tab Description
    General
    • Change the trigger name in the Name field.
    • You can disable the trigger by clicking Disable trigger. This restricts the database from starting the trigger automatically.
    • Select For update, For insert, or For delete to indicate the condition under which the trigger is to be invoked when the associated table is modified.
    Source Manually edit the SQL code for the trigger in the Source tab. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers from the context menu.
    DDL Select this tab to view the DDL for the trigger. Content in this tab is not modifiable.
  4. When you are finished editing the trigger, choose File > Save from the main WorkSpace menu to save your changes.
Related concepts
Triggers
Related tasks
Creating a SQL Anywhere Trigger
Creating an ASE Trigger
Editing a SQL Anywhere Trigger
Dropping a Trigger
Renaming a Trigger

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.