Home Oracle Commands

DROP INDEXTYPE

Drop an indextype.

Syntax:

   DROP INDEXTYPE [schema.]indextype [FORCE]

FORCE will drop even if the indextype is referenced by a domain index. In this case the index becomes invalid.

Related Commands:

INDEXTYPE - CREATE INDEXTYPE
INDEX - CREATE INDEX

Related Views:

 DBA_INDEXTYPES           ALL_INDEXTYPES           USER_INDEXTYPES 
 DBA_INDEXTYPE_OPERATORS  ALL_INDEXTYPE_OPERATORS  USER_INDEXTYPE_OPERATORS   




Back to the Top

Simon Sheppard
SS64.com