Neoview SQL Reference Manual (R2.5)

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 242).
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 “Database Object Names” (page 242).
Considerations for DROP INDEX
For indexes on materialized views, see “Indexes and Materialized Views” (page 66).
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 113