參照完整性
參照完整性，又稱引用完整性，是數據的屬性，用以表明引用之有效。參照的完整性不允許關係中有不存在的實體引用。[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.