Indexes Tab, Table Designer

The Indexes 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.

• Collate
  Specifies a collating sequence for the index tag. Click the arrow to select a Visual FoxPro collating sequence from the drop-down list. The default setting is "Machine".

• Insert Button
  Inserts a new index above the selected index in the grid.

• Delete button
  Deletes the selected index from the grid.

See Also

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