Unique keys

Contains a list of the table's unique keys. Following properties are displayed for each key:

Constraint name – name of the key. According to SQL language rules, each unique key should have a name. If the user does not specify any name for a unique key being created, then the system generates a name automatically.

Key columns – contains a list of the table's fields (columns) which constitute the unique key.

There are two buttons in the pane:

Add – activates the properties' pane to add a new unique key of the table;

Delete – deletes the key selected in the list.

Unique key properties

Field Constraint name allows specifying a name for the unique key. This name can be used later for manual composing SQL expressions for processing the table.

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

Key columns – a list containing those columns which constitute the unique key.

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

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

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

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