Tag Archives: Cascade

Referential Integrity Options (Cascade, Set Null and Set Default)

Ever wonder why there are only two options under the INSERT and UPDATE Specification of a foreign key? Why is there no Insert Rule? And to which table in the relationship do these rules apply? Let’s start at the beginning. Relationships in a database are implemented with foreign keys and primary keys. (For a primer … Continue reading Referential Integrity Options (Cascade, Set Null and Set Default)