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

Equivalent SQL Server command:

DROP PARTITION SCHEME