This dialog provides options for the creation and editing of a primary key.
The Set Primary Key dialog has the following components:
Index information Provides information on the index.
Index name Enter a name for the index. For primary key indexes, the name is set to primary and cannot be changed.
Unique index Select Unique index to ensure that values are unique and not null. For primary key indexes, this option is checked and cannot be changed.
Unique key Select Unique key to ensure that values are unique. They may be null. For primary key indexes, this option is checked and cannot be changed.
Indexed Columns Allows you to add or remove columns from the primary key index.
Columns in the table Lists all columns in the table that are not in the primary key index. Click a column to select it, or hold down Control to select more than one column at a time.
Asc.>> Click Asc.>> to add one or more columns, chosen from the Columns in table list, to the index in ascending order.
Desc.>> Click Desc.>> to add one or more columns, chosen from the Columns in table list, to the index in descending order.
<< Click << to remove one or more columns, chosen from the Columns in the index list, from the index.
Columns in the index Lists all columns in the primary key index. Click a column to select it, or hold down Control to select more than one column at a time.