HP 3000 Manuals HP 3000 Manuals
DROP INDEX
The DROP INDEX statement deletes the specified index.
Scope
ISQL or Application Programs
SQL Syntax
DROP INDEX [Owner.]IndexName [FROM [Owner.]TableName]
Parameters
[Owner.]IndexName is the name of the index to be dropped. It may
include the name of the owner of the table which
has the index.
[Owner.]TableName is the name of the table upon which the index was
created.
Description
* If a table name is not specified, the index name must be unique
for the specified or implicit owner. The implicit owner, in the
absence of a specified table or owner, is the current DBEUserID.
* Only indexes appearing in the system view SYSTEM.INDEX may be
removed with this statement. Hash table structures cannot be
dropped by using this statement; the hash structure can only be
removed by dropping the table with the DROP TABLE statement.
Neither unique constraint indexes nor referential constraint
virtual indexes can be dropped with this statement. Constraints
can only be removed through the ALTER TABLE DROP CONSTRAINT
statement or the DROP TABLE statement.
* Issuing the DROP INDEX statement can invalidate stored sections.
Refer to the ALLBASE/SQL Database Administration Guide for
additional information on section validation.
* If no index owner is specified and no table is specified, the
default owner is the current DBEUserID.
* If no index owner is specified and a table is specified, the
default rule owner is the table owner.
* If a table is specified and no owner is specified for it, the
default table owner is the current DBEUserID.
* The table and index owners must be the same.
Authorization
You can issue this statement if you have INDEX or OWNER authority for the
table or if you have DBA authority.
Example
DROP INDEX PartsOrderedIndex
FROM PurchDB.OrderItems
Alternatively:
DROP INDEX PurchDB.PartsOrderedIndex
If you discover that an index does not improve the speed of data access,
you can delete it. If applications change, you can redefine the index.