Online Documentation for SQL Manager for InterBase/Firebird

Specifying index properties


Use the Index page of the Index Editor dialog to specify common index properties.

 

Tables - Index Editor

 

Name

Specifies index name (if necessary, you can edit the one assigned by default).

 

Use the Index type section to define the created index type:

 

RadioButton Index

This option indicates that the index is defined by a field or a number of fields.

 

RadioButton Expression Index

This option indicates that index is defined by the expression from the Expression value tab.

 

CheckBox Index Active

Enables/disables the index immediately after it is created or changes applied.

 

Order

Use the drop-down list to select whether the ascending or descending sorting order should be used for index columns.