Indexes Tab, Table Designer
The Index tab appears in the Table Designer. It contains a scrollable grid for defining indexes. The grid has four columns.
Mover button
This is the double-headed arrow button at the extreme left of the row. Once you have entered two or more rows, use the mover button to move a row up or down in the list.Order
Specifies the sort order for the index. An up arrow indicates an ascending sort; a down arrow, descending.Name
Specifies the index tag name for the index. The arrow button to the left of the index name specifies ascending or descending order. Select the index, and then click on the arrow button to change the order.Type
Specifies the type of index: Primary (only if the table is contained in a database), Candidate, or Regular (the default). When you click a cell in this column, a list appears from which you can select a type. An entry is not required in this field.Only one index in a table can be set as Primary in the Type column.
Note If a table contains a unique index tag, the Table Designer will list that type, but the designer no longer provides this tag option.
Expression
Specifies the index expression, such as a field name. Click the button to create or edit an expression in the Expression Builder Dialog Box. An expression can be up to 240 characters.Filter
Specifies the filter expression. Click the button to create or edit an expression in the Expression Builder dialog box.Insert Button
Inserts a new index above the selected index in the grid.Delete button
Deletes the selected index from the grid.
Expression Builder Dialog Box | FOR( ) Function | INDEX Command | SYS(14) - Index Expression | SYS(2021) - Filtered Index Expression | Table Designer | Table Tab, Table Designer | Table Wizard