SQL SEVER 2017 TUTORIAL 9 : Referential Integrity
Referential integrity is a property of data stating references within it are valid. In the context of relational databases, it requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute (column) in a different (or the same) relation (table).
For referential integrity to hold in a relational database, any column in a base table that is declared a foreign key can contain either a null value, or only values from a parent table's primary key or a candidate key.[2] In other words, when a foreign key value is used it must reference a valid, existing primary key in the parent table. For instance, deleting a record that contains a value referred to by a foreign key in another table would break referential integrity. Some relational database management systems (RDBMS) can enforce referential integrity, normally either by deleting the foreign key rows as well to maintain integrity, or by returning an error and not performing the delete. Which method is used may be determined by a referential integrity constraint defined in a data dictionary.
The adjective 'referential' describes the action that a foreign key performs, 'referring' to a link column in another table. In simple terms, 'referential integrity' is a guarantee that the target it 'refers' to will be found. A lack of referential integrity in a database can lead relational databases to return incomplete data, usually with no indication of an error.
' SQL SEVER 2017 TUTORIAL 9 : Referential Integrity ' Explains how to use it in your database or tables.
there are 4 options :
1. no action
2. cascade
3. set null
4. set default
cascade delete and cascade update are the most popular options..
It is vary easy to set it with sql server management studio - ssms .
Nesta página do site você pode assistir ao vídeo on-line SQL SEVER 2017 TUTORIAL 9 : Referential Integrity duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário G. Tech 02 Fevereiro 2018, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 3,533 vezes e gostou 15 espectadores. Boa visualização!
