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 ( 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. This can be dropped with DROP CONSTRAINT clause.
  • 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.
  • 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);