Partager via


Indexes Tab, Table Designer

The Indexes tab in the Table Designer makes it possible for you to create indexes for a table.

  • Mover button
    Moves an index entry up or down the list. Appears as button with a double-headed arrow to the left of the index row after you enter two or more rows.

  • 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 an optional index type. A table can have only one index set as the primary index in the Type column.

    Note

    If a table contains an index with Unique type, the Table Designer displays that type; however, the designer no longer provides the Unique type as an available option.

    For more information about index types, see Visual FoxPro Index Types.

  • 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

Reference

Table Tab, Table Designer

Fields Tab, Table Designer

INDEX Command

SYS(14) - Index Expression

SYS(2021) - Filtered Index Expression

Table Designer (Visual FoxPro)