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:

INDEXTYPE - CREATE INDEXTYPE
INDEX - CREATE INDEX

 DBA_INDEXTYPES          ALL_INDEXTYPES           USER_INDEXTYPES
 DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS  USER_INDEXTYPE_OPERATORS


© Copyright SS64.com 1999-2014
Some rights reserved