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
What is the difference between push and pull subscription? : sql server replication
Tell me what are cursors and when they are useful?
If user is owning any SQL Objects, can we drop that user
What is measure group, measure? : sql server analysis services, ssas
What is the recommended total size of your memory optimized tables?
List out the differences between global and local temp tables in sql server?
What are the different types of sql server replication? : sql server replication
What do you mean by an execution plan? Why is it used?
How to connect sql server management studio express to sql server 2005 express?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How many primary keys are possible in a table?
How to drop existing views from a database in ms sql server?
How to create new tables with "select ... Into" statements in ms sql server?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Distinguish between commit and rollback?