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.