What is Referential Integrity?

Answer Posted / vasant

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. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is fmtonly in sql?

722


How do I view a table in sql?

720


what does myisamchk do? : Sql dba

742


What is sql and explain its components?

799


What's the difference between a primary key and a clustered index?

717






How to run sql statements with oracle sql developer?

791


What is the difference between the conventional and direct path loader? : aql loader

867


difference between anonymous blocks and sub-programs.

818


What is not null in sql?

781


What is offset in sql query?

822


Which command is used to delete a trigger?

956


What is a parameter query?

820


What are local and global variables and their differences?

810


Is clustered index a primary key?

691


What is parallel hint?

936