Changing unique keys

You can change a unique key for the table or nickname that you are altering. You can define more than one unique key for the same table or nickname.

• To change unique keys using the Control Center:
  1. Open the Alter Table notebook if you are adding a unique key to a table: From the Control Center, expand the object tree until you find the Tables folder. Click the Tables folder. Any existing tables are displayed in the pane on the right side of the window. Right-click the table you want in the contents pane and select Alter from the pop-up menu. The Alter Table notebook opens. If you are adding a unique key to a nickname, open the Alter Nickname notebook.
  2. On the Keys page, select a unique key from the table and click Change. The Change Unique Key window opens.
  3. Select the column or columns that you want to define as unique key columns.
  4. Optional: Type the constraint name of the unique key.
• To change unique keys using the command line, use the ALTER TABLE statement.