Creating a Trigger

Create a trigger on a table to enable checks whenever data is inserted, updated, or deleted.

  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, click Triggers, then click the drop-down arrow and select New.
  4. On the Name and Owner screen:
    1. Enter the name of the trigger.
    2. Select the owner of the trigger.
  5. On the Trigger Type screen:
    1. Select the events, that when executed, will call the trigger.
    2. Select Update of columns, then select the columns to be updated. If changes are made to any of the selected columns, the trigger executes.
  6. On the SQL Editor screen, enter the SQL statements for the new trigger and related table objects.
  7. (Optional) Click Summary to review your selected options.