Chapter 3 Building Physical Diagrams


Designating a foreign key

A foreign key is a primary key, or an alternate key, that migrates from another table. Depending on selected model options, a primary key can be automatically migrated to a child table as a foreign key at reference creation.

The columns that are defined in a foreign key can also be user-specified at creation and changed at any time from the Joins page of the reference property sheet.

For more information on the auto-migration of a foreign key, see section Auto-migrating foreign keys.

For more information on defining references, see section Defining references in a physical diagram.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.