參照完整性

參照完整性,又稱引用完整性,是數據的屬性,用以表明引用有效。參照的完整性不允許關係中有不存在的實體引用。[1]參照完整性與實體完整性二者,皆是關係模型必須滿足的完整性約束條件,其目的在於保證數據一致性

參考連結

  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.