On, Off

Off

Can be set for an individual connection or for the PUBLIC group. 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.

• sa_check_commit system procedure
• COMMIT statement
• Locks during inserts
• Referential integrity checking
• wait_for_commit connection property