19.5 DROP INDEX
Syntax
DROP INDEX [schema.]index [FORCE];
Purpose
Deletes a spatial index.
Keywords and Parameters
Value | Description |
---|---|
FORCE |
Causes the spatial index to be deleted from the system tables even if the index is marked in-progress or some other error condition occurs. |
Prerequisites
You must have EXECUTE privileges on the index type and its implementation type.
Usage Notes
Use DROP INDEX indexname FORCE to clean up after a failure in the CREATE INDEX statement.
Examples
The following example deletes a spatial index named OLDINDEX and forces the deletion to be performed even if the index is marked in-process or an error occurs.
DROP INDEX oldindex FORCE;
Related Topics
Parent topic: SQL Statements for Indexing Spatial Data