Procedure documentationDeleting Indexes Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You are the table owner or have INDEX privilege for the table.

    More information: SQL Reference Manual, Privilege Specification (privilege_specification)

  • The database is in the ONLINE operational state.

Procedure

  1. In the explorer tree, select the table to which the index belongs.

  2. In the context menu of the table, choose Definition.

  3. In the context menu of the editor window, choose Edit.

  4. Open the Indexes tab page.

  5. In the context menu of the index, choose Remove Index.

More Information

SQL Reference Manual, DROP INDEX Statement (drop_index_statement)