Progress
SQL-92
Guide and Reference


DROP INDEX Statement

Deletes an index on the specified table.

SYNTAX

DROP INDEX [ index_owner_name.]index_name  
    ON [ table_owner_name.]table_name  ; 

index_owner_name

Specifies the name of the index owner. If index_owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.

table_name

Verifies the index_name to correspond to the table. This argument is optional.

NOTE: You cannot drop the first index created on a table, except by dropping the table.

EXAMPLE

DROP INDEX custindex ON customer ; 

AUTHORIZATION

Must have DBA privilege or ownership of the index.

SQL COMPLIANCE

ODBC Core SQL grammar

ENVIRONMENT

Embedded SQL, interactive SQL , ODBC applications, JDBC applications

RELATED STATEMENTS

CREATE INDEX Statement


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095