Caché Parameter File Reference
ReferentialChecks
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Enable/disable validating the foreign key constraint.
Synopsis
[SQL]    ReferentialChecks=n
Description
The value n may be 1 or 0:
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).