docs.intersystems.com
Home / Configuration Parameter File Reference / [SQL] / ReferentialChecks


Configuration Parameter File Reference
ReferentialChecks
Previous section           Next section
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).


Previous section           Next section
View this book as PDF
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-02-15 22:51:05