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|
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.