Changing a unique key

Use the Change Unique Key window to modify a unique key for the table that you're creating. These steps are part of the larger task of creating a table. When you complete these steps, return to creating a table.

To change a unique key:

1. Optional: In the Change Unique Key window, define additional columns as unique key columns:
   1. In the Available columns box, select an additional column or columns that you want to define as unique key columns. The columns that you select cannot allow null values.

      You can define up to 64 columns to be unique key columns, and the sum of their lengths must not exceed 254.

   2. Click on the > push button to move the selected column or columns to the Unique key columns box.

2. Optional: Remove some columns from the list of unique key columns:
   1. In the Unique key columns box, select the columns that you do not want to have as unique key columns.

   2. Click on the < push button to move them to the Available columns box.

[Return to creating a table]