Online Documentation for SQL Manager for DB2

Index Editor


The Index Editor dialog allows you to view/edit table index properties.

 

Tables - Index Editorl

 

 

Use the Schema drop-down list to select the database schema for the index.

 

Use the Name edit box to set the index name. Note that the name of the index must be unique among all names of the index or index specifications described in the catalog.

 

The Fields for index area allows you to select indexed fields.

To select a field, you need to move it from the Available fields list to the Selected fields list. Use the Move all to Selected Move to Selected Move to Available Move all to Available buttons or drag-and-drop operations to move the fields from one list to another.

 

Index properties

This area allows you to specify a number of properties for the index.

 

For details see Index Editor.