Replacing a Trigger Definition

You can replace the SQL definition of a trigger.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, select Triggers.
  4. Choose one of the following:
    • Click the drop-down arrow on the trigger for which you want to replace the definition and select Replace.
    • From Triggers in the left pane, click the drop-down arrow and select New. Enter the name of the existing trigger for which you want to replace the definition.

      When selecting an existing trigger, the Confirm Replace dialog appears with an option to replace the object definition or cancel the replacement.

    The Replace Trigger wizard appears.
  5. (Optional) On the SQL Editor screen, enter the new trigger value.
  6. (Optional) On the Summary screen, verify the trigger name, and type.