Saving, Displaying, and Updating a Table's Index Definition

Your index is automatically saved in the database when you save your table or database diagram. The index is available for modification as soon as you create it.

To display and update index definitions

  1. In your database diagram, right-click the table and choose Properties from the shortcut menu.

    -or-

    Open the Table Designer for the table whose index you want to modify, right-click in the Table Designer, and choose Properties from the shortcut menu.

  2. Choose the Indexes/Keys tab.

  3. To update the definition, select the field you want to update and change its value or setting.

Your changes are saved to the database when you save the table or diagram.

Note that you can also manage indexes on some views.  For more information, see Indexed Views.

See Also

Indexes

Show: