Kbase P67069: What is Referential Integrity
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/10/2004 |
|
Status: Unverified
GOAL:
What is Referential Integrity
FIX:
1) The condition where the value stored in a database table's foreign key must either be null or be equal to some value in another table's matching unique or primary key. SQL provides two mechanisms to enforce referential integrity: constraints specified as part of CREATE TABLE statements prevent updates that violate referential integrity, and triggers specified in CREATE TRIGGER statements execute a stored procedure to enforce referential integrity.
2) The ensured consistency of file relationships.