Primary Key

A Primary Key uniquely identifies a record in a table and can consist of one or more columns. 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
SQL Server Primary Key Fill Factor is defined as the Tagged Value FILLFACTOR with a numerical value, within the Primary Key operation
 

Learn more

 

Learning Center topics

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