Primary Key


A primary key can be added to a database table.

Set a Primary Key:


Columns Grid of Database Explorer with a single column primary key.

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

In the Columns grid that appears in the lower right of this window, 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 other column's PK column. 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