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 attributes.
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.
See also:
Diagram Objects: Indexes | Index Manager