Physical Modeling › Indexes › Indexes Dialog

Indexes Dialog

A primary key (PK) and a foreign key (IF) index is automatically created for each table in your model, based on the primary key and foreign key columns. If you designate columns as an alternate key group (AK) or inversion entry group (IE), the equivalent unique (AK) and non-unique (IE) indexes are also generated.

Use the Indexes dialog to create alternate key (unique) and inversion entry (non-unique) indexes for tables in your model. After you create an index, you can use the Indexes dialog to modify its properties, such as the index name, column members, physical properties, and user-defined properties.

Note: You can use the Indexes dialog to create AK and IE indexes, but not a PK index or an IF index.

Use the following options and tabs in the Indexes dialog to view and update the properties for indexes:

• Table

  Lets you select a table from the dropdown. This field displays the table associated with the currently selected index. Click the button to open the Tables dialog in which you can edit the properties of the selected table.

• Index

  Lets you view all the indexes for the current table.

• Show FK Indexes

  Lets you view the foreign key indexes in the Index list.

• New

  Lets you add a new index in the New Index dialog.

• Rename

  Lets you rename the selected index in the Rename Index dialog.

• Delete

  Lets you delete the selected index.

  Note: You cannot delete a primary key or foreign key index. If you delete an alternate key or an inversion entry index, the columns that make up the index are not deleted. Only the alternate key or inversion entry index designator are deleted.

• Members

  Lets you create an index and select the column members of an index.

• <Database>

  Lets you specify physical storage properties for an index for all supported target servers, including Access and FoxPro target desktop servers. The name of this tab, and all DBMS-specific options, change dynamically depending on your target server.

• Comment

  Lets you add a comment for an index

• UDP

  Lets you specify user-defined property values for an index.