---
id: 1792
title: "Navigating the Waters of Foreign Key Constraints: The Role of ON UPDATE and ON DELETE"
source_domain: hackerone.com
source_url: "https://www.hackerone.com/blog/navigating-waters-foreign-key-constraints-role-update-and-delete"
published_at: "2024-03-25T04:12:49Z"
tags: ["databases", "sql", "foreign-keys", "referential-integrity", "data-modeling"]
phying_url: "https://phying.com/item/1792"
lang: en
---

# Navigating the Waters of Foreign Key Constraints: The Role of ON UPDATE and ON DELETE

## Summary

Foreign key constraints keep relational data consistent, while ON UPDATE and ON DELETE actions decide what happens when referenced rows change. A practical guide with SQL examples.

## Intelligence Metadata

- **Sources:** hackerone.com
- **Published:** 2024-03-25T04:12:49Z
- **Original:** https://www.hackerone.com/blog/navigating-waters-foreign-key-constraints-role-update-and-delete
- **Phying News:** https://phying.com/item/1792