Common

System Types Table Indices

Use this page to Add Indices.

To access this page:

  1. Select Common > System Types in the Navigation pane.
  2. Click theTables icon for a System Type.
  3. Click the Indices icon for a table.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field

Description

INDEX NAME

Displays name of index. 

UNIQUE INDEX

If checked, a unique index is built. Primary Key can’t also be checked. If Unique Index and Primary Key are both unchecked, a non-unique index is built.

PRIMARY KEY

If checked, index is built as a Primary Key for the table. Unique Index can’t also be checked. If Unique Index and Primary Key are both unchecked, a non-unique index is built.

CLUSTERED INDEX

If checked, index is marked as "clustered." 

NOTE:CLUSTERED INDEX can be used with PRIMARY KEY to create a clustered or non-clustered primary key.

NOTE: Refer to Microsoft SQL documentation on details for clustered indices.

Index Fields

Click the System Types Index Fields page to add, edit and delete table fields for the index.

SYSTEM SUPPLIED

If checked, this content is installed with the Stewardship Tier and cannot be edited.

If unchecked, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.