Deleting a Text Index

Remove one or more text indexes.

Prerequisites

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority REFERENCE permission on the underlying table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	You must have one of: DROP ANY INDEX system privilege DROP ANY OBJECT system privilege REFERENCE permission on the underlying table being indexed You own the underlying table being indexed You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes: MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

You must have one of:

You must also have EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes:

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects, and then select Text Indexes.
Select one or more text indexes 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 text indexes.
Verify that the list of text indexes to be deleted is correct and click Yes.