15.00 - Benefits of Referential Integrity - Teradata Database

Teradata Database Design

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

Benefits of Referential Integrity

 

              Benefit

                                                   Description

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.