docs.intersystems.com
Caché Parameter File Reference
ReferentialChecks
[Home] [Back] [Next]
InterSystems: The power behind what matters   
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).


Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA