Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

DROP INDEX

Description

Use the DROP INDEX statement to drop an index.

Syntax

DROP [ REVERSE ] [ UNIQUE ] INDEX index_name

[ON table_name] [ ; ]

  • REVERSE: Specifies that the index to be dropped is a reverse index.
  • UNIQUE: Specifies that the index to be dropped is a unique index.
  • index_name: Specifies the name of the index to be dropped. If omitted, a name is automatically assigned as i_<table_name>_<column_names>.
  • table_name: Specifies the name of the table whose index is to be dropped.
Example

The following are examples of many ways of dropping indexes:

DROP INDEX game_date_idx ON game;

DROP REVERSE INDEX gold_index ON participant;