Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Determines when foreign key integrity is checked, as data is manipulated.
Can be set for an individual connection, or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this
option for PUBLIC or for another user or role. Takes effect immediately.
If this option is set to On, the database does not check foreign key integrity until the next COMMIT statement. Otherwise,
all foreign keys that are not created with the check_on_commit option are checked as they are inserted, updated, or deleted.