Creating an index

Chapter 3 Building Physical Diagrams

Creating an index

You can either create a user defined index which is associated with one or more columns, or create an index that you link to a primary key, alternate key, or foreign key.

Index naming conventions

Use the following naming conventions for indexes:

Index	Naming convention
Primary key	Table code followed by PK; for example EMPLOYEE _PK
Foreign key	Table code followed by FK; for example PROJECT _ FK
Alternate key	Table code followed by AK; for example EMPLOYEE _ AK

Index ascending or descending order

You can indicate the index order for each column attached to an index, by selecting Ascending or Descending in the Sort column for each column listed on the Columns page of the Index property sheet.