参照完整性

参照完整性,又称引用完整性,是数据的属性,用以表明引用有效。参照的完整性不允许关系中有不存在的实体引用。[1]参照完整性与实体完整性二者,皆是关系模型必须满足的完整性约束条件,其目的在于保证数据一致性

参考链接

  1. Mike Chapple. . About.com. [2011-03-20]. (原始内容存档于2016-11-19). Definition: Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.