DROP INDEX

DROP INDEX

Syntax

drop_index ::=

Prerequisites

Only the SYS user, the owner of the schema containing the index, users having the INDEX object privilege on table, and users having the DROP ANY INDEX system privilege can execute the DROP INDEX statement.

Description

This statement is used to remove an index from the database.

user_name

This is used to specify the name of the owner of the index to be dropped. If omitted, Altibase will assume that the index belongs to the schema of the user connected via the current session.

index_name

This is used to specify the name of the index to drop.

Example

<Query> Delete the index emp_idx1.

iSQL> DROP INDEX emp_idx1;
Drop success.