What is referential integrity and how is it achieved?
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
How to invoke a trigger on demand?
What is reference section?
What is the full meaning of dml?
How to find Duplicate Records In table?
Explain about SQL server 2005?
In which files does sql server actually store data?
What is the maximum size of a row in sql server?
What are different backups available in sql server?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Why I am getting this error when dropping a database in ms sql server?
Is truncate a dml command?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the difference between push and pull subscription? : sql server replication
What is isolation levels?
What is application role in sql server database security? : sql server security