In this case, referential integrity has not been maintained. Using our tables as an example, let's say you have 10 records in the Customers table (with a CustomerId of 1 to 10), but your Orders table contains a record using a CustomerId of 11. This prevents foreign key values from having no corresponding primary key value in the referenced table. When you create a relationship, you also have the option to Enforce Referential Integrity (which we selected when we created our relationship).
0 Comments
Leave a Reply. |