#referential integrity in sql server

[bigdatansql]

Referential Integrity Constraints

A foreign key must match a primary key or be null in order to maintain referential integrity. In other words, every column in a base table that is declared a foreign key can only contain null values, values from a parent table's primary key, or values fro

A foreign key must match a primary key or be null in order to maintain referential integrity. In other words, every column in a base table that is declared a foreign key can only contain null values, values from a parent table’s primary key, or values from a candidate key for referential integrity to hold in a relational database. This will help you maintain data quality and ensure that no data…

View On WordPress