Interested to Buy Any Domain ? << Click Here >> for more details...
What is referential integrity and how is it achieved?
- 1 Answers
- 10861 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 SubQuery in SQL Server 2008
What is sleeping status in sql server?
What is a primary index?
How to list all tables in the database using odbc_tables()?
Explain system functions or built-in functions? What are different types of system functions?
Why use sub query in sql server and list out types of sub queries?
Tell me what is the stuff and how does it differ from the replace function?
What is a unique index?
When does a workload on SQL Azure get throttled?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
what are the new features introduced in sql server 2000? : Sql server database administration
What are the advantages of stored procedure in sql server?
What is 1nf normalization form?
What is trace flag in sql server?
What is inner join in sql server joins?
