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 Clause

Description

You can delete an index defined for a column by using the DROP INDEX clause.

Syntax

ALTER [ TABLE | CLASS ] table_name DROP [ REVERSE ] [ UNIQUE ] INDEX  index_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.
  • table_name : Specifies the name of a table that has an index attribute to be deleted.
  • index_name : Specifies the name of an index to be deleted.
Examples

ALTER TABLE a_tbl DROP INDEX i_a_tbl_age;

ALTER TABLE a_tbl DROP UNIQUE INDEX i_a_tbl_age;