Benefits of Referential Integrity - Teradata Database

Teradata Database Design

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Benefits of Referential Integrity




Maintains data consistency

Teradata Database enforces integrity relationships between tables based on the definition of a PK or a FK.

Maintains data integrity

When performing INSERT, UPDATE, and DELETE requests, Teradata Database maintains data integrity between referencing and referenced tables.

Increases development productivity

It is not necessary to code applications to enforce referential constraints because Teradata Database automatically enforces referential integrity.

Requires fewer programs to be written

Teradata Database prevents update activities from violating referential constraints.

Teradata Database enforces referential integrity in all environments; you need no additional programs.