参照完整性

维基百科,自由的百科全书
跳到导航 跳到搜索

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

参考链接[编辑]

  1. ^ Mike Chapple. Referential Integrity. About.com. [2011-03-20]. 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.