Procedure documentationChanging Index Properties Locate this document in the navigation structure

Prerequisites

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

  • You have the INDEX privilege for the table.

  • 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. Change the index definition.

    Note Note

    To display the definition as an SQL statement, choose Export SQL in the context menu of the editor.

    End of the note.

  5. In the context menu of the editor window, choose Alter Index.

More Information

SQL Reference Manual, ALTER INDEX Statement (alter_index_statement)