Name |
Enter a name for the foreign key in the text field.
|
Primary Table |
Specify the database, owner, and table.
|
Reference Constraint |
Specify the type and name of constraint referenced by the
foreign key.
|
Index Option (SQL Anywhere only)
|
Set the index option. Click Set Clustered Index to open the Set Clustered Index wizard. |
Columns Mapping |
Shows the mapping of foreign columns to primary
columns, including the datatype of each column. |
Action (SQL Anywhere and Sybase IQ
only) |
Specify actions to take on update and on delete. |
Not Null (SQL Anywhere and Sybase IQ
only)
|
Disallow null values in foreign-key columns. |
Check on Commit (SQL Anywhere and Sybase IQ
only)
|
Override any WAIT_FOR_COMMIT option. |
Comment (SQL Anywhere and Sybase IQ
only) |
(Optional) Specify a comment for the foreign key. |
Match Full |
Specify the constraint conditions on
the values of the referencing columns. If all values in the referencing columns
of a referencing row are:
- Null – the
referential integrity condition is true.
- Non-null – the
referential integrity condition is true if there is a referenced row where each
corresponding column is equal in the referenced table.
The referential integrity condition is false when:
- All values are
non-null and not equal, or
- Some values
in the referencing columns of a referencing row are non-null values, while
others are null.
|