ALTER permission on the underlying table
of the trigger
You own the underlying table of the
trigger
SAP Sybase IQ
16.0
You must have one of:
ALTER ANY OBJECT system privilege
ALTER ANY TABLE system privilege
You own the underlying table of the trigger
The SAP Sybase IQ resource is authenticated and
running.
In a multiplex
configuration, the coordinator node is running.
Task
In the Perspective Resources view, select the resource, and
select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects > Tables, and then selectTables or Proxy Tables.
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.
In the left pane, select Triggers.
Note:Triggers does not appear
when the selected table is not a system store table.
Select one or more triggers from the right pane and click
Delete.
Note: Use Shift-click or Control-click
to select multiple triggers.
Click Yes to confirm deletion.
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.