Primary Key

A Primary Key uniquely identifies a record in a table and can consist of one or more columns.

Topics

Topic

Detail

See also

Types of Primary Key

In Enterprise Architect, a:

Simple Primary Key (single column) is defined as the attribute of a stereotyped operation
Complex Primary Key (several columns) is defined as the stereotyped operation itself
 
For example, a column LastName might not be unique within a table, so a Primary Key is created from the LastName, FirstName and DateOfBirth columns.

 

Create a Primary Key

Learn more

 

Learning Center topics

(Alt+F1) | Database Engineering | Physical Data Model | Add Primary Key