> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# What is Referential Integrity?
- URL: https://nolongerset.com/under-100-referential-integrity/
- Published: 2021-09-30T01:30:03.000Z
- Updated: 2026-05-08T13:02:08.000Z
- Description: The concept of referential integrity explained in under 100 words.
- Author: Mike Wolfe
- Tags: Under 100, #Import 2026-05-20 02:59

Think of referential integrity as a **data contract**.

Let's say you create a relationship between *Customer.CustID* and *Order.CustID*.

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/09/image-83.png)

Your Customer table makes an **unbreakable promise** that no row will be deleted if there are one or more related records in the Order table. Likewise, the Order table promises to only refer to records that actually exist in the Customer table.

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/09/image-84.png)

### Bottom Line

With referential integrity in place, you can **safely make assumptions** about the relationships within your data. And that makes it easier to write your application.

---

*Image by [Gerd Altmann](https://pixabay.com/users/geralt-9301/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=2850276) from [Pixabay](https://pixabay.com/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=2850276)*