15.00 - Purpose - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Purpose

The intent of the referential integrity rule is to ensure that if some tuple r in relation variable R references some tuple s in relation variable S, then tuple s must exist.

This prevents you from corrupting the integrity of the database by deleting data that is still being used by another relation.