Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Context-Sensitive Help » UltraLite Plug-in Help » Introduction to UltraLite Plug-in property sheets

Database property sheet: Extended Information tab Next Page

Foreign Key property sheet: General tab


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.

See also