Online Documentation for SQL Manager for InterBase/Firebird

Selecting index fields

Use the Fields page of the Index Editor dialog to select the fields for the index.

Fields for index

To include field(s) in the index, you need to move it from the Available Fields list to the Selected Fields list. Use the  buttons or drag-and-drop operations to move the fields from one list to another.

Unique

Check this option to prevent inserting or updating duplicate values in indexed columns.

If the Expression Index option was selected at the Index tab then you need to define the expression at the Expression Value tab.