Primary Key


Set a Primary Key:


Columns Grid of Table Details showing a single column primary key.

In Database Explorer, click the table node to which you want to add a primary key.

In the Columns grid that appears in the lower right, click in the PK column to specify which column(s) make up the primary key

A key icon will appear for those columns composing the primary key.


Columns Grid of Database Explorer with a composite primary key.

To create composite or multicolumn primary key, click additional columns. A number will appear next to the primary key icon indicating this column's position in the primary key.

Note: No number will appear if the primary is composed only of a single column.


See also:

Database Tables
Table Columns