adspace


What is referential integrity ?

Answer Posted / pravin kadam

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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2353


Does group by remove duplicates?

1120


what is bcp? When does it used? : Sql dba

1065


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


How do I remove duplicates in two columns?

1202


what is dbms? : Sql dba

1070


Do we need to rebuild index after truncate?

1154


how many tables will create when we create table, what are they? : Sql dba

1155


Is primary key clustered index?

1028


what is sql server agent? : Sql dba

1188


define sql insert statement ? : Sql dba

1110


what is schema? : Sql dba

1163


what are the advantages of sql ? : Sql dba

1154


Is primary key always clustered index?

1101


What is the current version of sql?

1106