Indices tab

Use this tab to maintain the table indices and index fields of the table definition.

You can perform these actions:

Add indices and index fields:
- To add an index, click Add Index and enter the index properties in the grid. See the field help.
- To add an index field, select an index in the grid and click Add Child. Then, in the Name field, select the desired field from the list.
  Alternatively, right-click a field in the Fields tab and select Copy. Then, go back to the Indices tab, right-click an index and select Paste.
Remove indices and index fields. To remove an index or index field, right-click the index or field and select Remove.
To determine the index sequence, use the Up and Down buttons to move the index records up or down the list. The index numbers change correspondingly. The index with number 1 is the primary key.

All Table Indices

All table indices. Each index is represented by a record.

Name

The number of the index or the name of the index field.

Note: The index with number 1 is the primary key.

Description

The description of the index or index field.

You can only enter a description when you add an index. LN Studio stores the index description in a label.

Label

The label that contains the description of the index.

This field is read-only.

To open the label in the Label Editor, click the label icon.

Note: For new indices, the label is generated when you save the table.

This field does not apply to index fields.

Active

If this check box is selected, the index is active. The primary index (index number 1) is always active.

Note: This information is not used in the data dictionary or the database layer.

This field does not apply to index fields.

Unique

If this check box is selected, the index is unique. Therefore, different records must have different values in the index parts.

If this check box is cleared, different records can have the same values in the index parts. These are called duplicate records.

Note: This field does not apply to index fields.