Viewing or Modifying Table Trigger Properties

View or change trigger properties on a table, including the comment and the underlying SQL statement of the trigger.

Prerequisites
Database Version Table Trigger Privileges
SAP Sybase IQ 15.3 and 15.4 View any trigger property page – none.
Modify any trigger property – you must have one of:
  • DBA authority
  • RESOURCE authority, along with one of:
    • ALTER permission on the underlying table of the trigger
    • You own the underlying table of the trigger
SAP Sybase IQ 16.0

View any trigger property page – none.

Modify a trigger comment – you must have one of:
  • CREATE ANY TRIGGER system privilege
  • ALTER ANY TRIGGER system privilege
  • CREATE ANY OBJECT system privilege
  • ALTER ANY OBJECT system privilege
  • COMMENT ANY OBJECT system privilege
Note: ALTER permission on the table is not required to modify a comment.
Modify any other trigger property – Yyu must have one of:
  • ALTER ANY OBJECT system privilege
  • ALTER ANY TRIGGER system privilege, along with one of:
    • ALTER ANY TABLE system privilege
    • You own the underlying table of the trigger
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables or Proxy Tables.
  3. Select a table from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Table or Proxy Table Properties view appears.
  4. In the left pane, select Triggers.
    Note: Triggers does not appear when the selected table is not a system store table.
  5. In the right pane, select a trigger and click Edit.
    The Trigger Properties view appears.
  6. View or modify the properties.
    • Any modifications to the properties are saved when either Apply or OK is clicked
    • If you do not have privileges to modify properties, SAP Control Center displays the properties view in read–only mode.
    .
    Area Description
    General

    Name – (Read–only) The name of the trigger.

    Dialect – (Read–only) Indicates the dialect of the trigger.

    Events – (Read–only) Indicates the event which causes the trigger to fire. Valid events are:
    • Insert
    • Delete
    • Update
    • Update with Columns
    Tining – (Read–only) Indicates when the trigger fires. Valid times are:
    • Before the event (Table only)
    • Instead of the event
    • After the event
    • On a SQL Remote conflict

    Level – (Read–only) Defines whether the trigger fires at a row or statement level.

    Comment – An optional text comment on the trigger.
    SQL The SQL statement to be executed when the trigger fires.
  7. Do one of:
    • Click OK to update any changes to the database and exit the view.
    • Click Apply to update any changes the database, but remain in the view.
    • Click Cancel to cancel any changes not updated to the database and exit the view.
    Note: Unlike other wizards launched from the properties view, changes to triggers take effect immediately. You do not need to click OK or Apply in the properties view to upload the change to the database.
  8. Click OK.
Parent topic: Table Triggers
Related tasks
Creating a Table Trigger
Deleting a Table Trigger
Generating Table Trigger DDL Commands
Authenticating a Login Account for a Managed Resource
Related reference
Table Trigger Privilege Summary