Deleting a View

Delete an enabled or disabled view to remove it from the database. Deleting a view deletes the definition of the view. All data related to the view are virtual, and remain in the underlying tables after deletion.

Prerequisites

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You own the view
SAP Sybase IQ 16.0	You must have one of: DROP ANY VIEW system privilege DROP ANY OBJECT system privilege You own the view

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 > Views, and then select Views.
Select one or more views from the right pane and either:
- Click the arrow to the right of the name and select Delete, or
- From the Administration Console menu bar, select Resource > Delete.
Tip: Use Shift-click or Control-click to select multiple views.
Click Yes to confirm deletion.