Skip to main content
Previous sectionNext section

ReferentialChecks

Enable foreign key constraint validation.

Synopsis

[SQL]    ReferentialChecks=n

n is either 1 or 0. The default value is 1.

Description

When ReferentialChecks is enabled (n = 1), InterSystems IRIS® data platform validates the foreign key constraint for INSERT, UPDATE, DELETE, and TRUNCATE TABLE operations. When this parameter is not enabled, InterSystems IRIS bypasses validation of foreign key constraints.

For further details, refer to the DELETE, INSERT, TRUNCATE TABLE, and UPDATE commands in the InterSystems SQL Reference.

Changing This Parameter

To set the desired value for ReferentialChecks from the InterSystems Terminal, use the SetOption(“FilerRefIntegrity”) method of the %SYSTEM.SQL.Util class. See the class reference for details.

You can also change ReferentialChecks with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).