Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The General tab of the Foreign Key property sheet has the following components:
Name Shows the name of the foreign key. You can edit the name of the foreign key in 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 property.