Add Foreign Key

Use the Add Foreign Key window to specify new foreign keys for the table that you're creating. A foreign key is a column or set of columns in a table whose values are required to match at least one primary key value of a row of its parent table. A referential constraint is the rule that the values of the foreign key are valid only if either:

• They appear as values of a parent key (primary key).
• Some component of the foreign key is null.

You can add multiple foreign keys before closing this window.

Fields and controls

• Table schema
• Table name
• Primary key
• Available columns
• >, >>, <, <<
• Foreign key
• On delete
• On update
• Constraint name
• OK
• Cancel
• Apply