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 » SQL Anywhere Plug-in Help » Introduction to dialog boxes

Add Tracing Level dialog Next Page

Change Settings dialog


This dialog allows you to change the foreign key settings for check on commit, whether NULL values are allowed, and update and delete behavior.

The Change Settings dialog has the following components:

Allow null values    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.

Update action    Uses one of the following settings to define the behavior of the table when a user tries to update data:

Delete action    Uses one of the following settings to define the behavior of the table when a user tries to delete data:

Check only on a 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.

See also