DROP INDEX

Drop an index.

Syntax:

   DROP INDEX [schema.]index [FORCE]

Force can be used to drop domain indexes that are marked as 'loading' or are reporting errors.

Related Commands:

INDEX - CREATE INDEX
INDEX - ALTER INDEX

Related Views:

 DBA_INDEXES            ALL_INDEXES            USER_INDEXES 
                                                                INDEX_HISTOGRAM 
                                                                INDEX_STATS 
 DBA_INDEXTYPES           ALL_INDEXTYPES           USER_INDEXTYPES 
 DBA_INDEXTYPE_OPERATORS  ALL_INDEXTYPE_OPERATORS  USER_INDEXTYPE_OPERATORS 
 DBA_IND_COLUMNS        ALL_IND_COLUMNS        USER_IND_COLUMNS 
 DBA_IND_EXPRESSIONS    ALL_IND_EXPRESSIONS    USER_IND_EXPRESSIONS 
 DBA_IND_PARTITIONS     ALL_IND_PARTITIONS     USER_IND_PARTITIONS 
 DBA_IND_SUBPARTITIONS  ALL_IND_SUBPARTITIONS  USER_IND_SUBPARTITIONS    




Back to the Top

Simon Sheppard
SS64.com