Defining the primary key when altering a table

Use the Primary Key page of the Alter Table notebook to define the primary key for your table. A primary key is a column or set of columns that can be used to identify or access a particular row or rows. A primary key is a unique key, that is it is a key that is constrained so that no two of its values are equal. A table cannot have more than one primary key, and the columns of a primary key cannot contain null values.

Fields and controls



To define the primary key:

  1. Open the Alter Table notebook.
  2. Click on the Primary Key tab.
  3. In the Available columns box, select the column or columns that you want to define as primary key columns. You can define up to 16 columns to be primary key columns.
  4. Click on the > push button to move the selected column or columns to the Primary key columns box.
  5. Optional: In the Constraint name field, type the constraint name of the primary key.
  6. If you do not want to make any additional changes to the table, click on OK to alter your table and close the Alter Table notebook. Otherwise, continue on to one or more of the optional tasks.


Related information