What is referential integrity and how is it achieved?
- 1 Answers
- 10398 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 ssrs?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
Does index speed up select statements?
What type of locking occurs during the snapshot generation? : sql server replication
Can you pass expressions to function parameters?
How to Update from select query in sql server?
How to implement service broker?
What are unicode character string data types in ms sql server?
Which command is used for user defined error messages?
what do you understand by change data capture?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is a dbms wizard?
Can we use where and having clause together?
How do I edit a stored procedure in sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
