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 the Databases folder in Enterprise Explorer, under the database connection profile, expand the Databases folder, expand the tree for a database, and then expand the tree for the appropriate schema owner.
  2. Expand the view that contains the instead of trigger.
  3. Under the Instead of Triggers folder, right-click the trigger, and choose Edit.
  4. 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).
  5. Select File > Save from the main WorkSpace menu.
Parent topic: ASE Instead of Triggers

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.