When you use the management studio to create a foreign key constraint, you specify the relationship between two tables as well as the rules for enforcing referential integrity.
The association between tables is referred to as referential integrity. A primary key is required for each table in a database and can appear in other tables as a result of its connection to the data in those other tables. A foreign key is what is used when a primary key from one table appears in another table.
Foreign keys link, tables together and create table interdependence. Tables can provide a hierarchy of dependencies so that altering or removing a row from one table changes the meaning of adjacent rows in other tables.
Any rows that use that value as a foreign key lose their relevance when a row with a main key is deleted or updated with a different primary key. A foreign key's logical dependence on a primary key is known as referential integrity.
To learn more about referential integrity, refer
https://brainly.com/question/20217928
#SPJ4