Editing an ASE INSTEAD OF Trigger

Edit an INSTEAD OF trigger to change the name, trigger events, and other properties.

Prerequisites 

Be sure the data server that contains the trigger is running, and that you have created and established a connection to the data server.

  1. In Enterprise Explorer, expand the view that contains the INSTEAD OF trigger.
  2. In the Instead of Triggers folder, right-click the trigger, and choose Edit.
  3. Edit the INSTEAD OF trigger properties.
    Editor tab Description
    General
    • Change the Name.
    • Select Instead of Insert, Instead of Update, or Instead of Delete to indicate the condition under which the trigger invokes when the associated view is modified.
    Source Manually edit the SQL code for the trigger. To display line numbers for the SQL code, right-click in the left margin, and select Show Line Numbers.
    DDL View the DDL for the trigger (read-only).
  4. Select File > Save from the main WorkSpace menu.
  5. Click Save in the Preview Changes window to execute the SQL code and save the changes to the database.

    The Preview Changes window appears unless the option is unselected through the Schema Object Editor Configuration preference page.