Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity and how is it achieved?
- 1 Answers
- 10954 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
Explain following error properties?
What is the difference between mysql and sql server?
What is the purpose of the tempdb database?
Define inner join in sql server joins?
How can sql server instances be hidden? : sql server security
Explain about system stored procedure?
What is the difference between commit and rollback?
What are the types of sql server?
Do you know nested transaction?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How can a user-defined datatype be created?
Do you know the policy based administration feature of sql server 2008?
Can you explain what is the use of custom fields in report?
What is self contained multi valued query?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
