Adding a primary key

These steps are part of the larger tasks of creating a table and altering a table. When you complete the steps for adding a primary key, return to either creating a table or altering a table.



To define a primary key:

  1. On the Primary Key page, in the Available columns box, select the column or columns that you want to define as primary key columns. The columns you select cannot allow null values.

    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 Primary key columns box.

Depending on the task that you were doing when you added the primary key, return to either creating a table or altering a table.