The Index Editor is placed within the Table Editor dialog. It allows you to modify the list of table indexes as well as index properties.
The main element of the editor is the index list, which displays all indexes available within the table. The columns of the list allow you to modify the properties of the selected index.
These properties are:
Index Name
The name of the index, which must be unique within the table.
Unique
Defines the UNIQUE constraint for the selected columns. I.e. the combination of the included field values must be unique within the table;
Fields
The list of index fields.
Primary
This option makes the selected index primary, i.e. its included field combination is the main record identifier for the table;
Full-text
This option can be applied to the index if all its fields are CHAR, VARCHAR, or TEXT; it allows you to perform relevance-based search within the included fields.
The buttons under the list of indexes allows you to perform the following actions:
-
Add - add a new index with the default properties to the end of the list;
-
Duplicate - add a new index with the same properties as the selected index to the end of the list;
-
Delete - remove the selected index from the list;
-
Up/Down - move the selected index along the list.
Diagram Objects: Index Manager
©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.
