Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of placing primary key and foreign key
constrains on columns.
- 4 Answers
- 8293 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / jagadeesh b
If you maintain this relation ship you can get more advantages
1)you can not delete primary table directly..
2)duplicate values are not allowed in primary key table.
3)Null values are not inserted into primary key table so
validation is very easy fro m front end.(for ex; .net 2005).
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Tell me what is the order in which the sql query is executed?
What is dknf in normalization form?
Tell me what is a linked server?
How does Report Builder support Analysis Services cubes?
How to filter out duplications in the returning rows in ms sql server?
What is difference between views and stored procedures?
How to rebuild the master database?
What is the definition for sql server 2000?
Explain different types of lock modes in sql server 2000?
What is the difference between update lock and exclusive lock?
What are the different index configurations a table can have?
What is the importance of three tier architecture?
Why union all is faster than union?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are the disadvantages of merge replication?
