Neoview SQL Reference Manual (R2.4)

DROP INDEX Statement
• “Syntax Description of DROP INDEX”
• “Considerations for DROP INDEX”
• “Example of DROP INDEX”
The DROP INDEX statement drops a Neoview SQL index. See “Database Object Names”
(page 228).
DROP INDEX is a Neoview SQL extension.
DROP [VOLATILE] INDEX index
Syntax Description of DROP INDEX
index
is the index to drop.
For information, see “Identifiers” (page 252).
Considerations for DROP INDEX
Authorization and Availability Requirements
To drop an index, you must be the owner of the table associated with the index.
Example of DROP INDEX
• This example drops an index:
DROP INDEX myindex;
• This example drops a volatile index:
DROP VOLATILE INDEX vindex;
DROP INDEX Statement 109