Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

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

Note

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*