Alter Table -- Foreign Keys

Use the Foreign Keys page of the Alter Table notebook to alter the foreign keys for the table. 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 new foreign keys or alter or drop existing foreign keys.

Tasks

• Adding foreign keys
• Changing foreign keys

Fields and controls

• Foreign keys
• Add
• Change
• Remove
• OK
• Cancel

Related information

• Foreign keys -- See the SQL Reference
• Referential constraints -- See the SQL Reference
• Schemas -- See the SQL Reference
• Parent table -- See the SQL Reference
• Dependent table -- See the SQL Reference