Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

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

•	Create a Primary Key

•

•	Define a Primary Key Name Template

•	Foreign Keys

Learning Center topics

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

The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2014 Sparx Systems Pty Ltd.