DROP INDEX statement

The DROP INDEX statement removes an index from a table.

GUID-8AA7B9AC-AB44-48DB-865A-91FF4014DF38-low.png

To drop an index, you must have one of the following privileges:

  • Ownership of the object (the owner of the table or the index)
  • DBADM authority
  • PACKADM authority for the collection or for all collections

Important

Partitioned indexes can only be dropped with a DROP TABLESPACE statement on the associated table space.

If a unique index is dropped and that index was used to enforce the uniqueness of a parent key, the definition of the parent table is changed to incomplete.

DROP INDEX indexOwner.indexName

This option specifies the name of the index to be dropped.


Related topic

CDL-statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*