Create Table -- Foreign Keys

Use the Foreign Keys page of the Create Table notebook to specify the 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, change, or remove new foreign keys for your table. After the table is created, you must use the Alter function to add, change, or remove foreign keys.

Fields and controls

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