Skip to main content
Previous section   Next section

ReferentialChecks

Enable/disable validating the foreign key constraint.

Synopsis

[SQL]    ReferentialChecks=n

Description

The value n may be 1 or 0:

  • When 1 (true) Caché validates the foreign key constraint for INSERT, UPDATE, and DELETE operations.

  • When 0 (false) Caché bypasses validation of foreign key constraints.

Examples

ReferentialChecks=0

Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Perform Referential Integrity Checks on Foreign Keys for INSERT, UPDATE, and DELETE setting, choose Yes (true) or No (false).