 |
» |
|
|
|
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. |
