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
- 8652 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
Explain identity in sql server?
How will you know when statistics on a table are obsolete?
why would you call update statistics? : Sql server database administration
What are the advantages of using stored procedures in sql server?
What are the types of user defined functions in sql server?
What are the differences between char and nchar in ms sql server?
What stored by the model?
What are the basic functions for master, msdb, model, tempdb databases?
What is bcp? When does it use?
How to maintain a fill factor in existing indexes?
What are the different types of sub-queries?
Is port 1433 secure?
What is the purpose of sql profiler in sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
What are the fixed server level roles? : sql server security
