Common

System Types Table Indices

Use this page to Add Indices.

To access this page:

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

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.

DSP SUPPLIED

If checked, this content is installed with the platform 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.