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

SQL Anywhere 12.0.1 » Context-Sensitive Help » UltraLite plug-in help » UltraLite plug-in properties windows


Foreign Key Properties window: general tab

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