参照完整性
参照完整性,又称引用完整性,是数据的属性,用以表明引用之有效。参照的完整性不允许关系中有不存在的实体引用。[1]参照完整性与实体完整性二者,皆是关系模型必须满足的完整性约束条件,其目的在于保证数据一致性。
参考链接
- ^ Mike Chapple. Referential Integrity. 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.