Define a Primary Key Based on a Unique Index

Database tables often have one or more unique indexes defined for various purposes. It may be useful to define a primary key based on an existing index. To view the contents of a unique index in the Primary Key Editor, select Indexes from the Tools menu.

list unique indexes panel, described below right

Table

Name of the table for which the primary key is being defined.

Indexes

List of unique indexes for the table. To display the associated columns, select an index.

Creator ID
Creator ID of the table associated with the selected index.
Index Name
Name of the selected index.

To create or modify a primary key based on a unique index, select an index and select OK. The columns of the unique index replace all previously specified columns in the Key Columns box of the Primary Key Editor.

Columns

List of columns included in a selected unique index.

Column Name
Names of the columns that define the index.
Data Type
Attributes of each column in the index.