The Foreign Key constraint page displays the foreign key constraints that are defined for this table. You can add a new constraint, view a constraint definition, or remove a constraint. To create a new constraint, click Add. To remove a constraint, click Remove. To view the definition of a constraint, click Definition. You cannot change the constraint definition once the constraint is created. If you want to change a foreign key constraint, you must first delete the constraint and then recreate it.
To view the SQL used to build the constraint, select the constraint and click Show SQL. Once the table is created, Show SQL is unavailable unless a change is made.
The columns available in the foreign key constraint grid are:
Name
The SQL name of the constraint.Key columns
The key columns for the constraint.Parent table
The SQL name of the parent table.Parent key constraint
The SQL name of the key constraint from the parent table.Parent key columns
The key columns for the constraint from the parent table.
The constraint is created when you click OK on the Table Definition dialog.