Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity and how is it achieved?
- 1 Answers
- 10768 Views
- Adea Solutions, I also Faced
- E-Mail Answers
Answer Posted / koteshwar rao .palleboina
when foreign key constraint is created on a column
referential integrity is achieved .
when foreign key constraint is created on a column,that
column reference other column in the different table or
even in the same table but the reference column must be
primary key or unique key.
when a new value is added in a column referenced with
foreign key ,then the foreign key relation checks whether
the new value matches with the reference column or not.
If value matches then they are allowed into the table
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
What is normalization of database? What are its benefits?
What is index, cluster index and nonclustered index?
Is natural join and equi join same?
Does transparent data encryption provide encryption when transmitting data across the network?
How to how to convert numeric expression data types using the convert() function??
How to check if stored procedure is running in sql server?
How to use "begin ... End" statement structures in ms sql server?
What is difference between stored procedure and user defined function?
Explain the truncate command?
Do you know sql server 2008 backup compression?
What is field in algebra?
What is function of ROLLUP ?
How can you fetch alternate records from a table?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is triggers and stored procedures?
