Oracle7 Server SQL Reference

Contents Index Home Previous Next

DROP INDEX

Purpose

To remove an index from the database.

Prerequisites

The index must be in your own schema or you must have DROP ANY INDEX system privilege.

If you are using Trusted Oracle7 in DBMS MAC mode, your DBMS label must match the index's creation label or you must satisfy one of the following criteria:

Syntax

Keywords and Parameters

schema

is the schema containing the index. If you omit schema, Oracle7 assumes the index is in your own schema.

index

is the name of the index to be dropped.

Usage Notes

When the index is dropped all data blocks allocated to the index are returned to the index's tablespace.

Example

This command drops an index named MONOLITH:

DROP INDEX monolith

Related Topics

ALTER INDEX command [*]

CREATE INDEX command [*]

CREATE TABLE command [*]


Contents Index Home Previous Next