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. |