UltraLite Database User's Guide
  Utility Programs
    The UltraLite Schema Painter
      UltraLite Schema Painter dialogs

Set Index dialog

This dialog provides options for the creation of a new index.

The Set Index dialog has the following components:

• Index information    Provides information on the index.

  • Index name    Enter a name for the index.

  • Unique index    Select Unique index to ensure that values are unique and not null.

  • Unique key    Select Unique key to ensure that values are unique. They may be null.

• Indexed Columns    Allows you to add or remove columns from the index.

  • Columns in the table    Lists all columns in the table that are not in the index. Click on a column to select it, or hold down Control to select more than one column at a time.

  • Asc.>>    Click Asc.>> to add one or more columns, chosen from the Columns in table list, to the index in ascending order.

  • Desc.>>    Click Desc.>> to add one or more columns, chosen from the Columns in table list, to the index in descending order.

  • <<    Click << to remove one or more columns, chosen from the Columns in the index list, from the index.

  • Columns in the index    Lists all columns in the index. Click on a column to select it, or hold down Control to select more than one column at a time.