Requires ALTER permission on the underlying view of the trigger by virtue of any one of:
ALTER ANY OBJECT system privilege.
ALTER ANY VIEW system privilege.
You own the underlying view 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, select IQ Servers > Schema Objects > Views > Views.
Select a view from the right pane on which to create the trigger 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 Views Properties view appears.
In the left pane, select Triggers.
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.