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: