What is referential integrity ?

Answer Posted / rajesh

To establish a parent child relationship between two tables
and to prevent invalid data entry into the table , we make
set of rules on a column is called Referential integrity.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between db2 and sql?

611


how can we know the number of days between two given dates using mysql? : Sql dba

648


What is difference sql and mysql?

621


What is sqlca in powerbuilder?

649


How can we avoid duplicating records in a query?

668






Why do we need pl sql?

640


What are the advantages of indexing?

625


what does it mean to have quoted_identifier on? : Sql dba

780


what are the authentication modes in sql server? : Sql dba

625


what are the different tables present in mysql? : Sql dba

587


What is exit statement?

663


Where do we use pl sql?

641


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2078


what is the difference between truncate and drop statements? : Sql dba

642


what is sp_pkeys? : Transact sql

778