Previous Topic: The Table Index Editor

Next Topic: Find and Replace

Working with Data Models › Index Tables › Create an Index in the Table Index Editor

Create an Index in the Table Index Editor

Only one Primary Key index can apply to a table, although you can create multiple AK (unique) or IE (non-unique) indexes. You use the Table Index Editor to work with table indexes in a physical model.

To create an index in the Index Editor

  1. Right-click a table in the diagram and click Index Properties.

    The Table Index Editor opens.

  2. Click the New New icon in property editors to create a new object button on the toolbar.

    A new index is added to the Navigation Grid with a default name, which you can accept or change.

  3. Work with the following options:
    Show FK Indexes

    Specifies to display FK (foreign key) indexes in the Navigation Grid. Select the check box to enable this option.

    Physical Name

    Specifies the physical name of the table index. You can change the physical name of the table index in this field.

    Type

    Displays key designation of the table index.

    Is Unique

    Specifies if the table index is unique or non-unique. Select the check box if it is a unique index.

    Physical Only

    Specifies whether the table index should be suppressed from a logical model and appear in a physical model only.

    Generate

    Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

    Note: Depending on your target server, there can be more options.

  4. Click the Members tab to specify table index members.
  5. Click the General tab to define any additional table index properties.
  6. Click the Options tab to further define the table index.
  7. (Optional) Click the Comment tab and enter any comments that you want to associate with the table index.
  8. (Optional) Click the Where Used tab to view where the table index is used in the model.
  9. (Optional) Click the UDP tab to work with user-defined properties for the table index.
  10. (Optional) Click the Notes tab to view history information and view or edit user notes.
  11. Click Close.

    The table index is created and the Table Index Editor closes.