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   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-04-10 14:45:57