Adding a primary key

These steps are part of the larger tasks of creating a table and altering a table. When you complete these steps, 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 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 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.