Changing a unique key

These steps are part of the larger task of creating a table. When you complete these steps, return to creating a table.

To change an existing 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, nor can they be LOB or ROWID columns.

      You can define up to 64 columns to be primary 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.