Deleting a View Trigger

Delete triggers from a view.

Prerequisites
Database Version View Trigger Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You own the underlying view of the trigger
SAP Sybase IQ 16.0 You must have one of:
  • ALTER ANY OBJECT system privilege
  • ALTER ANY VIEW system privilege
  • You own the underlying view of the trigger
This gives you ALTER permission on the underlying view 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 > Views, and then select Views.
  3. 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.
  4. In the left pane, select Triggers.
  5. Select one or more triggers from the right pane and click Delete.
    Note: Use Shift-click or Control-click to select multiple triggers.
  6. 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.
Related tasks
Authenticating a Login Account for a Managed Resource