This tab has the following components:

Name   Shows the name of the foreign key. You can edit this field.

Type   Shows the type of object.

Foreign table   Shows the name of the table to which the foreign key applies.

Primary constraint   Shows the name of the primary key or unique constraint that the foreign key references.

Primary constraint type   Show the type of constraint the foreign key references. This can only be a primary key or a unique constraint.

Primary table   Shows the table containing the primary key or unique constraint in this foreign key relationship.

Allows null   Determines whether the foreign key columns allow NULL values. To use this option, the foreign key columns must all have Allow Nulls set to Yes.

Check on commit   Forces the database to wait for a COMMIT before checking the integrity of the foreign key, overriding the setting of the wait_for_commit database option.

Maximum hash size   Shows an integer value for the maximum hash size in the range [0,32]. The default maximum hash size is the value of the database property maximum hash size when the database was created, which has a default of 4. See UltraLite max_hash_size creation parameter.

 See also