Skip to Main Content
IBM Db2 11.1 Certification Guide
book

IBM Db2 11.1 Certification Guide

by Robert (Kent) Collins, Mohankumar Saraswatipura
June 2018
Intermediate to advanced content levelIntermediate to advanced
478 pages
10h 52m
English
Packt Publishing
Content preview from IBM Db2 11.1 Certification Guide

The delete rule for referential constraints

The delete rule controls how the delete operations are performed against a parent table participating in a referential integrity constraint. The four possible behaviors with a delete rule are as follows:

  • ON DELETE CASCADE: This ensures that whenever a record from the parent table of a referential integrity constraint is deleted, all dependent records in the child table that have matching primary key values in their foreign key are deleted as well.
  • ON DELETE SET NULL: This ensures that whenever a record from the parent table of a referential integrity constraint is deleted, all the dependent records in the child table that have matching primary key values in their foreign key are set to NULL. For ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Red Hat RHCSA 8 Cert Guide: EX200, 2nd Edition

Red Hat RHCSA 8 Cert Guide: EX200, 2nd Edition

Sander van Vugt

Publisher Resources

ISBN: 9781788626910Other