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. There are the following two ways to specify the index to be dropped:

  • To specify the name of the index
  • To specify the name of the table or the column where the index is specified
Syntax

DROP [ REVERSE ] [ UNIQUE ] INDEX index_name

[ON table_name ( column_name [ {, column_name } ...) ] [   ]

 

DROP [ REVERSE ] [ UNIQUE ] INDEX

  ON table_name ( column_name [ {, column_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.
  • table_name : Specifies the name of the table whose index is to be dropped.
  • column_name  : Specifies the name of the column whose index is to be dropped.
Example

The following are examples of many ways of dropping indexes:

DROP INDEX ON game(medal)

 

DROP INDEX game_date_idx

 

DROP REVERSE INDEX gold_index ON participant(gold)

 

DROP INDEX name_nation_idx ON athlete(name, nation_code)