What is referential integrity ?

Answer Posted / mallikarjuna.anumala

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use joins?

775


How do sql databases work?

710


What are the dml statements?

854


how many sql ddl commands are supported by 'mysql'? : Sql dba

702


Does view contain data?

788






what is the difference between a local and a global temporary table? : Sql dba

741


How do I add a database to sql?

777


what is primary key? : Sql dba

710


What is audit logout in sql profiler?

764


What is dbo in sql?

706


What found sql?

701


What is a recursive join sql?

806


how do you know if your mysql server is alive? : Sql dba

778


What is the difference between rollback and rollback to statements?

806


What are the parts of a sql statement?

765