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
- 8471 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
What is the most common type of join?
What is sql server profiler?
Explain temporary table vs table variable by using cursor alternative?
What are types of scd? : sql server analysis services, ssas
Can foreign key be deleted?
Some queries related to SQL
Can I delete event logs?
What is best institute to Learn DotNET And SQL in chennai?
How can delete duplicate records in cte in sql server?
What are SSL and TSL protocols?
What is the use of “join” in sql server?
What are scheduled tasks in sql server?
What are the general features of sql server management studio? : sql server management studio
What is compound operators?
what are the critical issues you have resloved in your company
