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 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.

 

Tables - Index Editor - Fields

 

 

CheckBox Unique

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

 

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

 

Tables - Index Editor - Expression