What does Referential Integrity mean in SQL?

[reetus]

Hi Friends,

I am learning the SQL from couple of days. It was easy to understand the concepts of constraints, integrity. But I am getting more difficulties to understand the "Referential Integrity" concept.
I think it is one of the more complex topic in the SQL. If you have sound knowledge about the Referential Integrity then please share with me, so that it will be easy for me to understand Referential Integrity.

[Praetor]

Hi,

*.Referential Integrity is used to maintain the relationship in the RDBMS.The method for maintaining relationships among database tables is called as Referential integrity.

*.foreign keys is used to enforce the Referential Integrity

*.A relationship among two tables of the database referred as referencing tables. Foreign key is useful in this process. And it is maintained by using constraint

[Katty]

See something below can help you..

1.Referential integrity is a essential property in the process of database design.

2.The process of Bonding tables together is also referred as Referential integrity.

3.Referential integrity can be break by the deletion on the foreign key value of the other table.

4.Referential integrity the process of pointing to value of table from value of the another table.

[kelfro]

Hi friend,

I don't know more about the Referential Integrity, as it very tough to understand.

Please visit the below link, on this site you will get useful information regarding Referential Integrity .

http://publib.boulder.ibm.com/infoce...integrity.html