Indexes

Contains a list of indexes of the table being created. For each index following properties are displayed:

Name – name of the index. The user should specify a name for each index being created.

Columns – contains the enumeration of fields (columns) of the table used for building the index.

There are two buttons in the pane:

Add – activates the properties pane to add a new index of the table;

Delete – deletes the index selected in the list.

Index properties

Field Name allows specifying a name for the table's index. This name can be used later for manual composing SQL expressions for processing the table.

Box Uniqueness is checked in the case when there is confidence that no two records of the table being indexed can have equal values in all columns of the index. This condition will be trivially fulfilled if the set of the index columns coincides with the set of columns of the primary key or of a unique key.

Available columns – a list containing all columns (fields) of the table which are not included into the index.

Index columns a list containing those columns which constitute the index. For each column the list contains its name and the sorting order by values of this column (increasing or decreasing).

Buttons > and < serve to move table columns from the list of available columns to the list of index columns and vice versa.

Button << cleans the list of index columns (i.e. it moves all columns to the list of available columns).

Buttons Up and Down allows changing order of columns in the index.

Button Save transfers values of fields of this pane to a selected row of the list of indexes.