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: