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 required. Modify any trigger property – Requires 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 required. Modify a trigger comment – Requires 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: Requires 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.

Database Version

Table Trigger Privileges

SAP Sybase IQ 15.3 and 15.4

View any trigger property page – None required.

Modify any trigger property – Requires 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 required.

Modify a trigger comment – Requires one of:

Note: ALTER permission on the table is not required to modify a comment.

Modify any other trigger property:

Requires 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

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Tables.
Select Tables or Proxy Tables.
Select a table or proxy 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.
In the left pane, select Triggers.

Note: Triggers does not appear when the selected table is not a system store table.
In the right pane, select a trigger and click Edit.
The Trigger Properties view appears.

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, Sybase 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.

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:

Tining – (Read–only) Indicates when the trigger fires. Valid times are:

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.

Click OK or Apply to close the Trigger properties 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.